Hello,
I'm looking at some code that uses the RadGrid1.MasterTableView.ExportToExcel()
type command. It sends the grid to excel just fine. However, when my client wants to save the excel file, it defaults as a web page rather than xls format. Looking at the documentation on this, my hunch is that its because the function really is sending html to excel, rather than a native xls format. Is this assumption correct?
The grid comes up in excel just as needed.
My main question is there a way to have the default excel function save the file as an xls? That is, when the user clicks "save as" in excel, it defaults to web page. I know that all the user would have to do is click file type as xls in excel. However, there are many users, and sometimes this step is overlooked which then results in a missing document in their process. If the data given to excel in a way that it would know it's "save-as" default should be xls. I didn't know if xml/csv would solve this problem or have similar side affects.
I should point out that I'm not doing much editing of the grid before sending it to the ExportToExcel(). Only setting blank columns' visual=false.
I should point out this is on IE8, and I'm coding in C#
Thanks in advance for assistance.
I'm looking at some code that uses the RadGrid1.MasterTableView.ExportToExcel()
type command. It sends the grid to excel just fine. However, when my client wants to save the excel file, it defaults as a web page rather than xls format. Looking at the documentation on this, my hunch is that its because the function really is sending html to excel, rather than a native xls format. Is this assumption correct?
The grid comes up in excel just as needed.
My main question is there a way to have the default excel function save the file as an xls? That is, when the user clicks "save as" in excel, it defaults to web page. I know that all the user would have to do is click file type as xls in excel. However, there are many users, and sometimes this step is overlooked which then results in a missing document in their process. If the data given to excel in a way that it would know it's "save-as" default should be xls. I didn't know if xml/csv would solve this problem or have similar side affects.
I should point out that I'm not doing much editing of the grid before sending it to the ExportToExcel(). Only setting blank columns' visual=false.
I should point out this is on IE8, and I'm coding in C#
Thanks in advance for assistance.