Reporting Module Save File as XLS - Cell Borders

Ignition
1

Ignition Platform 8.1.24

Reporting Module 6.1.24 (licensed)

I have a report that I need to output as a native XLS, which to everything I am seeing is working (IE xls file extension, Excel doesn’t flag it as a filetype mismatch). The issue I have is I can’t get rid of the borders around my data in a Table. No amount of adjusting TextShape stroke settings is actually making a difference. Excel opens the worksheet with grid lines turned off, and borders on only the cells that have data. Is there a way to get rid of the borders or would this be Excel doing this when opening? I need XLS (and not CSV or XLSX) so the data can be imported into an older (and worse) system and while I don’t think the borders will be a problem for another team taking care of the import I’d like to remove them to just jump past that possible next hurdle. Thank you.

2

Ignition comes with the Apache POI libraries for manipulating MS Office file types, including XLSX. If you don't like how the reporting module constructs Excel files, you have the option to construct them entirely programmatically (outside the report module) with complete control over every cell's content and format. You can even read in a partially populated Excel file as a template, inject suitable data from Ignition, and write the composite file.

Start here:

https://forum.inductiveautomation.com/search?q=apache%20poi%20script%20excel%20order%3Alatest

3

I’ll definitely look into it, does the machine hosting Ignition have to have Excel installed on it?

Thanks as always!

4

No, actual copy of Excel is not required.

5

Perfect, thanks again!