Click OK in the Add References dialog box to accept your selections. In Visual Studio 2005, locate Microsoft Excel 11.0 Object Library on the COM tab.īut I was not prompted to “generate wrappers” ( I don’t know what does it means !) like in the third step (below)ģ. On the COM tab, locate Microsoft Excel Object Library, and then click Select. On the Project menu, click Add Reference.Ģ. I did open a command dos, went to the dir which contains O2010pia.msi When I click on it, it has unzipped 3 files o2010pia_eula.txt,
Have first downloaded on this site PIARedist.exe I wanted to learn to make excel file, and fill it as I want using C# program I use office 2010, and visual studio 2010 express C# Now.ToString( "yyyyMMddhhmmss" ) + ".xls", .XlFileFormat.xlExcel7) OWB.SaveAs(strMyFileNamePath.ToString() + strMyDestFileName.ToString() +ĭate. OWB = oYB.Open(strMyFileNamePath + strMyFileName)ĬType (oSheets.Item(1), .Worksheet) Anyone know why the object is limited in size? Here's an incomplete snippet of what I'm doing:ĭim oXL As .Applicationĭim oYB As .Workbooksĭim oWB As .Workbookĭim oSheets As .Sheetsĭim oSheet As .Worksheetĭim oRG As .Range My result set is larger than 16K but not more than 65K rows. It should run the full 65K rows if I need it. I'm using Excel 2003 and Excel Interop version 11 (even tried 12). I've been able to use by adding a reference as mentioned above, however when I create a workbook and do a 'save as' (even without any formatting) it only saves 16843 (16K) of rows.
0 kommentar(er)
