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
(837 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 LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 4
(831 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
(778 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
(755 Views)