MS Office Report Express VI - row limit

[sakubh]

Hi All!

I have problem using MS Office Express VI when I'm trying to send a lot of measurement data. I'm sending a 5 columns of data and when I have more than approx. 130 000 samples then the MS Office Express VI doesn't create report. I see MS Excel opens and closes immediately. When I'm sending less data there is no problem. Also when I have more than 130 000 rows of data and using export to excel directly in labview chart there is no problem. It looks like MS Office Express VI has row limit but I couldn't find the information about this. Any help needed 🙂

Kind Regards

[ben64 · Accepted solution]

---

sakubh a écrit :

Hi All!

I have problem using MS Office Express VI when I'm trying to send a lot of measurement data. I'm sending a 5 columns of data and when I have more than approx. 130 000 samples then the MS Office Express VI doesn't create report. I see MS Excel opens and closes immediately. When I'm sending less data there is no problem. Also when I have more than 130 000 rows of data and using export to excel directly in labview chart there is no problem. It looks like MS Office Express VI has row limit but I couldn't find the information about this. Any help needed 🙂

Kind Regards

---

The Office Express vi uses a .xlt template when you use the Basic Report for Excel setting. So the generated .xls report will be limited to 65536 rows. You can create your own .xltx template and set the Express vi to Custom Report For Excel. This way you will be able to write up to a million rows to a .xlsx file.

Ben64

[sakubh]

Thanks for help! I was using Excel 2003 Template (.xlt) which was limited to 65536 rows and 256 columns. My solution for the problem is to save the same Excel Template in Excel 2007 (.xltx) format. Excel 2007 is limited to 1048576 rows and 16384 columns. Previously I could save only 10 minutes of measurement data, now I can save almost 3 hours of measurement data.

Kind Regards

Sakubh