LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Xcel to .csv convertor

Hello All,

 

Is there any VI available to covert the Xcel file (having multiple sheets inside it) to .csv file.

 

For example we have 1 xcel file with 10 sheets(sheet1,sheet2,sheet3,sheet4) we want 10 csv files from VI.

 

Any help is welcomed.

0 Kudos
Message 1 of 4
(100 Views)

Hi Lamar,

 


@LamarDaviss wrote:

Is there any VI available to covert the Xcel file (having multiple sheets inside it) to .csv file.

For example we have 1 xcel file with 10 sheets(sheet1,sheet2,sheet3,sheet4) we want 10 csv files from VI.


I guess you are asking about Excel XLS* files to be converted into several CSV files!?

Yes, there are VIs available: use functions from ReportGenerationToolkit (aka RGT)!

 

This way you can open/read XLS* files and get the individual sheets to be saved as CSV file (using WriteDelimitedSpreadsheetFile)…

(Keep in mind you need MSOffice installed on your computer to be able to use the RGT functions!)

Best regards,
GerdW

using LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
0 Kudos
Message 2 of 4
(94 Views)

The easiest way to convert an Excel file (which may have lots of features other than rows and columns of numeric data, which characterizes a .CSV file, such as Graphs, pictures, the use of color and shading in cells, etc.) is to open it using a little-known program called Microsoft Excel, and ask Excel to save it as a text (.txt) or Comma-Separated Values (.csv) file.  You need Excel, but don't need LabVIEW to do this.  Conversely, if you start with LabVIEW, you will need the additional Report Generation Toolkit from NI or a third-party application to open and read files with the .xls or .xlsx format.

 

Bob Schor

0 Kudos
Message 3 of 4
(41 Views)

I believe LibreOffice can open xlsx files and can export them (assuming you don't have a license for Excel).

0 Kudos
Message 4 of 4
(18 Views)