Jump to content

How to marge excel files


Recommended Posts

Hi Team,

I'm a new member, start to learn and use Labview 2 month ago.

I need your assist with excel files....

I have 12 of excel files that I want to combine into one excel file. I want the data from each worksheet to get piled up into one big file, in one excel workbook.

For example:

First excel file A.xls with 2 worksheet A1 and A2.

Second excel file B.xls with 2 worksheet B1 and B2.

etc....

Finaly. I would like to creat Vi and get One Excel File (For Example... c.xls) which is including 4 worksheet --> A1, A2, B1, B2 with all the data.

Thanks in advance,

Nachmany

Link to post
Share on other sites

LabVIEW doesn't support the XLS format natively, so you'll need to google around on Excel automation. It's accomplished by using an ActiveX object to communicate to Excel.

Link to post
Share on other sites

Hi todd,

For creat xls file i use "Write To Spreadsheet File.vi"

It's work fine, and finaly I get Excel file (xls or xlsx).

Sorry but my LabView software not including "report generation toolkit".

Please advice, if you have any solution to marge xls files.

Best Regards,

Nachmany

Link to post
Share on other sites

Write to Spreadsheet file, does not produce an Excel file.

It produces a file that Excel converts into an Excel file (you could open the file with any text editor like Notepad).

Excel files like you need are build using the Excel ActiveX interface, and the Report Generation Toolkit is a method to control that.

However I won't be surprised if there isn't some VBA on the internet (Excel code) to merge Excel files into one file with different sheets per source file.

Ton

Link to post
Share on other sites

Write to Spreadsheet file, does not produce an Excel file.

It produces a file that Excel converts into an Excel file (you could open the file with any text editor like Notepad).

Excel files like you need are build using the Excel ActiveX interface, and the Report Generation Toolkit is a method to control that.

However I won't be surprised if there isn't some VBA on the internet (Excel code) to merge Excel files into one file with different sheets per source file.

Ton

exactly.

if you want to do it easily in LabVIEW get the RGT, if not do the ActiveX work. You'll be better off in the long run with the RGT since everyone has a need to export to Excel and you'll just wind up recreating the toolkit.

Link to post
Share on other sites

if you want to do it easily in LabVIEW get the RGT, if not do the ActiveX work. You'll be better off in the long run with the RGT since everyone has a need to export to Excel and you'll just wind up recreating the toolkit.

I've only ever used the RGT for outputting Excel-format files. It has the capability to read as well?

Link to post
Share on other sites

I've only ever used the RGT for outputting Excel-format files. It has the capability to read as well?

To a degree, yes. You can read the data in from existing files. I suppose it depends on what formatting exists and if it is standard across the different documents on how much you would wind up doing with the toolkit and at which point you'd just grab the activeX references and do it yourself.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By Porter
      This package contains VIs for reading and writing to CSV files that follow the CSV format outlined in RFC-4180 (see http://tools.ietf.org/html/rfc4180). Using this package, you can properly import CSV files that were exported from spreadsheet programs such as Microsoft Excel, Open Office or LibreOffice Calc as well as export CSV files that will be compatible with any program capable of interpreting CSV files.
       
      This implementation of the CSV format is capable of handling escaped fields such as those containing commas (or other field delimiters), multiple lines, and double quotes.
       
      Notes:
      - Starting from V1.1.0, library files are located in "<LabVIEW>\vi.lib\LAVA\Robust CSV" and example is located in "<LabVIEW>\examples\LAVA\Robust CSV".
      Development version available on GitHub: https://github.com/rfporter/Robust-CSV
    • By Porter
      View File Robust CSV
      This package contains VIs for reading and writing to CSV files that follow the CSV format outlined in RFC-4180 (see http://tools.ietf.org/html/rfc4180). Using this package, you can properly import CSV files that were exported from spreadsheet programs such as Microsoft Excel, Open Office or LibreOffice Calc as well as export CSV files that will be compatible with any program capable of interpreting CSV files.
       
      This implementation of the CSV format is capable of handling escaped fields such as those containing commas (or other field delimiters), multiple lines, and double quotes.
       
      Notes:
      - Starting from V1.1.0, library files are located in "<LabVIEW>\vi.lib\LAVA\Robust CSV" and example is located in "<LabVIEW>\examples\LAVA\Robust CSV".
      Development version available on GitHub: https://github.com/rfporter/Robust-CSV
      Submitter Porter Submitted 02/21/2014 Category Database & File IO LabVIEW Version 8.6 License Type BSD (Most common)  
    • By Aishwarya Saravanan
      My project involves designing a front end for a synchronous generator using LabVIEW.   It is actually data acquisition and display of signals in a file.   The problem I face when building a program is that:   1)the sampling rate is set to 100 samples with 1 kHz sampling frequency.These signals are generated by daq assistant and i have used merge signals to merge these signals from daq assistant as well  as signals from other radio buttons and Boolean as well. The problem is that when written on a file I am able to see only one instance of Boolean status for every 100 samples daq assistant creates.   2) now iam able to write only 0/1 as status of Boolean in the file.How will I write on /off into file?

    • By Gab
      Hello,
      Is it possble to put signatureline into excel footer using Active X ?
    • By Paul Liu
      Hi All,
      I am a new user to LabView and this is my first project using it. The project requires me to read a massive spreadsheet from Excel into LabView and then allowing the user to do the following:
      - Select which columns to plot against the first column
      - Use a cursor to select a portion of the spreadsheet: the Vi will then average the selected data by column (in other words, if the user selects data across multiple columns, the program will average data in each column separately). Then write the averages to the csv file.
      So far, I have the spreadsheet read into a table as strings (because the first row of the spreadsheet is words). I have spent a lot of time searching how to allow the user to select data on the table to perform operations on, but to no avail. I am hoping you guys could give me some insight on how to tackle this project.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.