How can I insert a Bitmap object into an Excel cell without creating any temporary gif file in the server? And how can I store the Excel file using Response stream instead of FileStream? Public Microsoft.Office.Interop.Excel.Picture Add (double Left, double Top, double Width, double Height); Public Function Add (Left As Double, Top As Double, Width As Double, Height As Double) As Picture. Left Double Double Double. Top Double Double Double. Width Double Double Double. Height Double Double Double.
'Tim Wallace' wrote in messagenews:[email protected]. I need to insert a row into an Excel spreadsheet using C#. I get areference to the app, the workbook, the sheet. When I attempt to callInsert, I keep getting errors, probably because I'm not certain what theargs are (and cannot find any documentation to help). I supplied the 2args as I thought were correct (Microsoft.Office.Inerop.Excel.XlDirection.xlUp, rownum ), but these don'tseem correct.
Can anyone please help or point me to a valid Web source?Can't you use ADO.NET with an Excel connection string instead? Then you justuse T-SQL INSERT statements:).
Yes, if he defines a range. You can also use adox to change the schemawithout instantiating Excel. Office automation is evil.-Derek Davis'Danny Tuppeny' wrote in messagenews:[email protected].
'Tim Wallace' wrote in messagenews:[email protected]. I need to insert a row into an Excel spreadsheet using C#. I get areference to the app, the workbook, the sheet. When I attempt to callInsert, I keep getting errors, probably because I'm not certain what theargs are (and cannot find any documentation to help). I supplied the 2args as I thought were correct (Microsoft.Office.Inerop.Excel.XlDirection.xlUp, rownum ), but these don'tseem correct. Can anyone please help or point me to a valid Web source?Can't you use ADO.NET with an Excel connection string instead?
Then youjust use T-SQL INSERT statements:).
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |