how to write a large amount of measured results with "write to spreadsheet " function in an Excel file?!

[worldviol]

I am going to measure more than 100,000 sampls and I have to write it in an document. I would like to use Excel to present it much more easier but the problem is here that excel can have just 60,000 samples. also using text file is not desired one.

do you have any solution that helps me ?!?!

[nhatnguyen]

Hello!

I wonder! Why don't you use tookit report?

You can write data in a table and then write to excel by tookit report!

[PaulG. · Accepted solution]

Excel 2007 gives you 1M rows. Can you update your version of Excel?

[smercurio_fc]

What makes it "easier" in terms of it being in Excel? You said you have more than 100,000 samples. Are you doing something with that data in Excel? For example, are you creating graphs?

[worldviol]

thanks for reply, according to ur advice I already tried but I just got confused. would you please tell me how to do it in detail ?!

[worldviol]

YEs, I have to present in an graph. kind of measurement's result presentation to find  charactristics.

[worldviol]

thanks for reply, according to ur advice I already tried but I just got confused. would you please tell me how to do it in detail ?!

[smercurio_fc]

Tried what and got confused about what? What details are you asking about?

[crossrulz]

Do you have to have the graphs in Excel?  Would a png file work?  If so, then you could create the graph in LabVIEW and then export the graph image to a png file.

[DFGray]

<fullDisclosure> I am a National Instruments employee.  But I was an industrial physicist for 12 years before coming to National Instruments. </fullDisclosure>

I find Excel to be difficult to work with when you have more than about 2000 points.  With 100,000, you are way over that limit.  Before I joined NI, I would have used Mathematica to do analysis and plotting of that sort of data.  But LabVIEW will do it very easily, as well.  Other NI software which can help are DIAdem or the report generation toolkit (as mentioned above).  For specific types of analysis, you can also check out Wikipedia's list of open source analysis programs.