write to spreadsheet and read from spreadsheet

[WeberM]

hello,

i've got a problem.
in my application i export waveforms to spreadsheet.
my data from the spreadsheet contains hundret of rows per second.
When i read the data from spreadsheet and add this data to a chart there are only values each second and not between the seconds.
what can i do to solve this problem. or is there a solution in LV?

markus

[SreedharT]

Hi,

There is ofcourse a simple solution. Because, if I store a 1000Samples/sec in my spread sheet, I am able to recover it, without any problem. But before proceeding any further, can you just attach the data that you have and the vi that you are using, so that it can be modified properly.

Thanks

[WeberM]

here is a example of a spreadsheet. the used vi to write this spreadsheet is called "Export Waveforms To Spreadsheet File (1D)".
You found it Functions/Waveform/WaveformFile IO.

[becktho]

Hallo Markus

Der Zeitstempel, den du in deiner Datei hast, ist mit einer Sekunde zu ungenau. Wenn du die Daten nicht als Waveform-Datei speichern kannst, würde ich dir empfehlen, zusätzlich in einer Kopfzeile das dt zu speichern. Dieses kannst du beim Laden der Datei dazu verwenden, wieder einen Waveform zu bilden. Die Informationen die ein Waveform enthält sind Startzeitpunkt (x0), Zeit zwischen zwei Messpunkten (dt) und die Daten selbst (Y). Wenn du das dt abspeicherst hast du alle Infos und du solltest ohne Probleme einen Graphen generieren können.

Thomas

[SreedharT]

Hi,

I have done two things:

1. I have simulated the conditions of a 2-D array (1000 x 10) and saved the same in the spread sheet (abc.xls).
2. I have taken your file, and converted it to a spread sheet file and saved the same (xyz.xls).

Go through the attachments. Hope this works.

[Y3G]

Hi

I have a problem that is much simplier than discussed.

I need to read from a spreadsheet file (see attached file), but somehow I get just the first culomn.

I have used all kinds of delimitters (tab, space)

Thanks for any hints

Yariv3G

What do I wrong on the ReadFromSpreadsheet.vi?

[MJBrehm]

Im running into the same problem as Yariv3g ...  Was wondering why I was getting empty arrays in my programs, and I relized the read from spreadsheet is basically not working for me.

I have it setup exactly like yariv, and have also used all sorts of different delimiters, and formatting.

[Donald]

---

MJBrehm wrote:
Im running into the same problem as Yariv3g ... 
I have it setup exactly like yariv, and have also used all sorts of different delimiters, and formatting.

---

yariv3g's problem was identified and solved in this thread.

If your problem isn't exactly the same, it may be best to post an example of your spreadsheet and vi.

[MJBrehm]

figured it out... I was trying to read from an excel file, which was saved as an excel workbook file. Changed the file format to text ( tab delimited ) ... and all the data popped right up.