Free Support Forum - aspose.com

Export not working as expected

Aspose.Cells Product Family
#1

I am using GridDesktop.

I am using this code to export:

However it doesn't export the column headings that I setup in the sheet.

How do I export the column headings?

string filename;

saveFileDialog1.DefaultExt = ".xls";

saveFileDialog1.ShowDialog();

filename = saveFileDialog1.FileName;

if (filename.IndexOf(".xls") < 0)

filename = filename + ".xls";

filename = saveFileDialog1.FileName;

gridDesktop1.ExportExcelFile(filename);

Process.Start(filename);
#2

Hi,

Could you create a sample application to show the issue, we will check your issue soon.

Thank you.

#3

create any old sheet.

Add these lines:

sheet.Columns[0].Header = “This does not export”;

and run the export.

#4

Hi,

OK, now i understand you, you need to export Custom Column Headers to Excel. This is not supported. I think you should use some inline column headers instead. By the way how could create custom column headers in MS Excel and let us know if MS Excel allows this.

Thank you.