Hi All,
I am new to infragistics &.net platform and have some issue with my application which i am working on. could any one help me out in solving the issue. Let me explain you in detail.
I have an excel template with of around 10,000 records in it. Except 3 columns all other column in the sheet has the formulas.
So, what i have decided is to design a front-end screen which takes the date range,the item name+ hourly data as the input and when you hit the export button it should call the existing excel template ( i dont want the output in a new excel file) and insert these data in the particular columns. other columns will change automatically (has formulas in it).
Design:
To export the data i used ultrawebgrid & the Infragristics ExcelExporter. My issue arises here i couldnt able to send the data to the exisiting excel template from the grid where as i can easily call the new excel file which i dont need to.
Could anyone tell help me with code how & where to call the existing template. The above code gives the result in new excelsheet. All your help is highly appreciated.
Thanks in Advance.
Dura
You can use the Workbook.Load static method to load an existing workbook file. Then you can modify the data and save the Workbook out again.
Mike,
Thanks for the reply. But i am using Infragistics.UltraWebGridExcelExport version 6.2 in that i dont have Load method.
I tried using version 7.3 dll of UltrawebgridExcelExport and it doesnt either showed me the load method. Can you please explain me step by step on how to call dll in licenses.licx. I feel the error is because of not specifiying the dll properly in licenses.licx file.
Thanks once again.
-Dura
The ability to load existing workbook files was added in version 7.2. You should be able to use it in the 7.3 version. Make sure you are trying to access the static Load method on the Infragistics.Excel.Workbook class and not the grid exporter class. As far as the licx file, the Excel assembly cannot be used at design-time, so the licenses file should never be involved.