I am currently testing your product to see if it fit my needs. It looks great but I have few problems. I want to use the exceldesigner with a template of an excel file and smartmarker. How can I populate an exceldesigner object with a datagrid?
I basically have a page with a datagrid and a chart representing the value of the datagrid and I would like to export the datagrid and the chart to excel. I would like to be able to customize the excel spreadsheet by using smartmarker. I have been able to export the grid by using importDataGrid, but that does not import the column header. Moreover I do not know how to use the smartmarker when we import the data from a datagrid.
.NET doesn't provide a method to get the column header of a datagrid so we don't know how to import them. You can use ImportDataGrid method to import data in datagrid and set the column header by your code.
Because we cannot know the column header of a datagrid, we don't have a smooth way to make it work with smart marker. I think you can manually import data in a datagrid and populate them in a DataTable, then set this datatable as a data source.
From what you are telling and from what I read in the doc, it sounds a lot more flexible to import or setthedatasource to a dataview or Datatable. However the importDatagrid looks lot more efficient because I do not have to reconnect to the database to get the data and put it into a DataSet or Dataview or Datatable.
The header problem is not a real problem for my case, however, with the importDataGrid, can I have the flexibility of choosing where the Data from the grid is going to be shown on the excel spreadsheat? For example starting showing the data at the cells D15. In my grid I have hidden column that shows as a blank column in excel after doing the importDatagrid. Is there a way to prevent that without having to use Datatable or Dataview?