...
You will see that the formulas have been stretched and updated as described above.
Final Code
Csharpcode | ||
---|---|---|
1 | 1 | using SoftArtisans.OfficeWriter.ExcelWriter; ... ExcelTemplate XLT = new ExcelTemplate(); XLT.Open(Page.MapPath("//templates//part1_template.xlsx")); DataBindingProperties dataProps = XLT.CreateDataBindingProperties(); object[] valuesArray = { "FY 2004", "Canadian Division", "Research and Development" }; string[] columnNamesArray = { "FiscalYear", "Division", "Group" }; XLT.BindRowData(valuesArray, columnNamesArray, "Header", dataProps); DataTable dtTop5 = GetCSVData(Page.MapPath("//data//Part1_Top5Expenses.csv")); DataTable dtAll = GetCSVData(Page.MapPath("//data//Part1_AllExpenses.csv")); XLT.BindData(dtTop5, "Top 5 Expenses", dataProps); XLT.BindData(dtAll, "All Expenses", dataProps); XLT.Process(); XLT.Save(Page.Response, "Part1_Output.xlsx", false); |
Vbnet | 1 | 1 |
Downloads
You can download the code for the Basic ExcelWriter Tutorials as a Visual Studio solution, which includes the Simple Expense Summary.
...