3/16/2024 0 Comments Excel text import wizard shortcut#DATE_LAST_SAVED#T#TIME_LAST_SAVED#ZIn your AHK script use the following to insert the proper dates: Replace the Date and Time with Replacement Keys: For example, in the header section there are the following four fields: Then, replace the mutable fields with some kind of replacement key. * I made the suggestion, above, to "chop up the XML file into 'templates'" – by that I mean into something like a header section, a body section, and a footer section. * Set the ss:ExpandedRowCount attribute (in the tag) to some large number (greater than the number of Rows that you ever expect to occur) - I usually set it to 32000 tags ), load it into Excel, then save it as an XLS document. Now, when I want to format some SQL output into an Excel spreadsheet, all I have to do is manually load it into Excel, "pretty it up", save it as an "XML Spreadsheet", chop up the XML file into "templates" and use AHK to re-assemble it, inserting the SQL data into the proper places (i.e. I was able to use XML to solve this problem (or more exactly: SpreadSheetML).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |