02-22-2021 02:32 AM
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.
02-22-2021 02:45 AM
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!)
02-22-2021 06:51 PM
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
02-23-2021 11:01 AM
I believe LibreOffice can open xlsx files and can export them (assuming you don't have a license for Excel).