Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to spool through worksheets in a workbook
I am copying a template worksheet in excel many times within a foreach
loop using c#. I then need to move to the first worksheet I copied to populate it brfore moving onto the next sheet. Does anyone have some code on this. I would appreciate your help on this thanks. Cyril Code he // spool thro the tables extracting the base currency // as we need to create a new sheet for every base currency returned. int _workSheetIdx = 1; Excel.Sheets sheets = this.Worksheets; Excel.Worksheet _wsTemplate = (Excel.Worksheet)Sheets.get_Item(_workSheetIdx); _wsTemplate.Name = "Template"; foreach (System.Data.DataTable dtBc in ds.Tables) { _wsTemplate.Copy(Type.Missing, _wsTemplate); _workSheetIdx++; _wsTemplate = (Excel.Worksheet)this.Sheets[_workSheetIdx]; _wsTemplate.Name = dtBc.Rows[0]["BaseCurrencyCode"].ToString(); PopulateCurrentWorkSheet(dtBc, _wsTemplate); } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
copying worksheets to a new workbook without formulae referencing original workbook | Excel Programming | |||
xls spool file doesn't automatically link to new xls file | Excel Discussion (Misc queries) | |||
Copy four worksheets from one workbook into a new workbook.e-mail | Excel Programming | |||
Link multiple worksheets in one workbook to another workbook and . | Excel Programming |