I have created a streamserve application to generate Excel output (.xlsx) using XMLOUT as follows:
1> I have unzipped the output .xlsx file doc and prepared the XMLOUT for each of the XML files generated after extraction.
2> I have created templates using the above extracted XML files and mapped with each XMLOUT by setting the run time output file path as structured in the unzipped folder of the xlsx.
3> 25 XMLOUT processes have been used for the above step. Can anybody let me know whether any other alternative is there for generating the same folder structure as extracted from xlsx. I'm worrying about the perfornance as well as its maintenance.
4> I have put the commands to zip the output files generated and rename the file with .xlsx (inside execute function in Job After script).
5> Though the complete folder structure is getting generated with the .xlsx file in the configured output path, but I'm unable to open the file; getting error as "Excel found unreadable content in <file>.Do you want to recover the contents of this workbook?If you trust the source of this workbook,click Yes."After clicking Yes, the message "The Workbook can't be opened/repaired by Microsoft Excel because it is corrupt" getting displayed and the file isn't opened.
Need help on this. If anybody has earlier faced this problem or have successfully generated the excel sheet, please help me out on this.
Note - When I zip the xlsx file using winrar GUI outside streamserve, I'm able to open the file with good formatting, but with the error in sharedString.xml file and the excel isn't able to display all the cell data.
But while trying to execute from the command line to zip or using streamserve execute function, I'm not able to open the file though the folder structure is getting generated properly.
I have used the following commands from command line/execute function
i) zip C:\TEST\OUT\TMP\CBS.zip C:\TEST\OUT\TMP\*.*
ii) SET WINRAR="C:\Program Files\WinRAR"
%WINRAR%\WinRAR.exe a -afzip "C:\TEST\OUT\CBS.zip" ""C:\TEST\OUT\TMP\*"
Tried with different options with different compression level using m[0,..5], but getting the same error.
Can somebody help me to figure the command to be used for zipping if already have done earlier?
or any other alternative?
Thanks & Regards,