So I have been playing with the export text file functions of Servoy for a little while now.
I previously had been creating tab text files and name it with a “.xls” on the end of it. Excel will open it right up and off you go. The problem with this is that there is no column or row formating available on a tab file. Excel will default all column and row sizes regardless of what is in the cells.
I then started to playing with making an HTML file with a table and formatting the table. I then save it out as an “.xls”. Once again it opens right up in Excel. The HTML tags seemed to force some kind of column and row control over the data. The problem is that when you go to save the file, Excel calls it Workbook1. It does not hold the filename once it is opened in Excel.
Does anyone know of an HTML tag that I can add to my file that Excel will use to keep the filename?
Or perhaps I should format the data another way besides using HTML tags. XML maybe? I don’t know.
Anyway, if anyone has any insight into this, I would love to hear from you.