Hi,

I have generated a report in EXL2K format. My team is working to merge multiple EXL2K reports into one .xls file. They are reading EXL2K output files in .NET and merging them.

When they tried to read report output file, they were getting data into HTML format, instead of Excel. Due to this, they are unable to merge files.

I know that WebFOCUS generate reports into HTML format and then it printing that report over MS Excel.

How can I force WebFOCUS to generate report in Excel, actually? Please help me here.


Thanks,
Sandy

This message has been edited. Last edited by: Tamra,

Try format EXL07 or XLSX format, if its available.

Hi Waz,

I already tried XLSX format, which generate reports into .xlsx format and this type of reports are readable in .NET.

But, in .xlsx format report, I am facing style issue for report heading. In .xlsx format, report heading is showing with some extra height, like below:


Could you please help me to reduce this extra height of row?

Thanks,
Sandy

sandy2sagar,

You already asked the same question in another post.
Please do not duplicate question.