Can I Write Data to a *.xlxsx File Without Screwing Up the Excel File Formatting?

[diarmaede]

I'd like to programatically add LabVIEW-generated data to a nicely-formatted *.xlsx file, one with all the right borders and column widths, etc.  But every time I try to add the LabVIEW data, the xlsx file formatting gets all screwed up and the file gets corrupted.  Is there a way around this?

Thanks!

- FB

[SteveChandler]

How are you modifying it? Are you using the XML parser? However you are doing it you have to make sure you are paying close attention to the spec in the MSDN. I have never used it but the report generation toolkit might help a lot.

[nathand · Accepted solution]

It will probably be easier to use ActiveX to control Excel and modify the file that way if you have that option, instead of writing the XML directly.

[SteveChandler]

Absolutely! But even that is a pain. I don't know for sure but I would imagine that the report generation toolkit uses ActiveX under the hood.

[nathand]

---

@Steve Chandler wrote:

Absolutely! But even that is a pain. I don't know for sure but I would imagine that the report generation toolkit uses ActiveX under the hood.

---

Yes, the Report Generation Toolkit uses ActiveX automation to build Excel and Word reports.

[LVbum42]

FB,

I was able to find the following link on the NI website.  I think it addresses the issue you are describing using the Excel ActiveX interface.

AutoFit Columns and Rows in Excel Using LabVIEW: http://digital.ni.com/public.nsf/allkb/8697100BBFA68902862571D4006D893B?OpenDocument

Regards,

Isaac S.

[diarmaede]

I'm slogging my way up the ActiveX learning curve.  It's challenging, but fun.