If you don't want to change your existing scripts too much, you would need to find a technology that can convert html tables to xls or xlsx and utilize it in fw_exit.fwx. Your scripts would have to set the value of a public variable, indicating whether the output should stay as HTML or be converted to XLS (or XLSX). In cases where the output needs to be converted to XLSX, you will need to grab the output buffer (Response.OutputBuffer), extract the table element and its contents, and process it with the converter to create the Excel file. After that the code will need to replace the content of the output buffer with the new output.

 

A quick search on "convert html to excel command line" yielded HTMLConverter, but I don't know anything about it and there may be other utilities that are better suited for your needs.

 

By the way, I see this solution as a hack. It should work fine, but it's pretty heavyweight in terms of server resources and does not give you too much control over the format of the Excel files. A better solution would be to create the files directly in each fwx script, rather than creating HTML and then converting it. The technology for this will vary, depending on whether you want to create XLS or XLSX (OpenXML) output.

FoxWeb Support Team support@foxweb.com email