excel-interop
How to use COM interop to show Excel window inside windows form
I want to display an excel inside my .net Windows Application. How can I do this using COM开发者_JAVA技巧 interop[详细]
2023-02-22 20:58 分类:问答Can you paste a block of cells in one shot using Excel Interop w/o using the clipboard?
I\'m trying to transfer data from a DataSet into an Excel workbook. Unfortunately, I need more control than I can get by simply linking to Excel via ADO.NET and using standard SQL to select and insert[详细]
2023-02-22 08:21 分类:问答Extend Formula Range Using Excel Interop
I\'m using the Excel Interop libraries to take 开发者_Python百科a sheet and replace values in the sheet. My sheet structure is as follows:[详细]
2023-02-21 22:29 分类:问答How to determine what "Ne" port the Adobe PDF printer is on?
How can I detect what port (Ne01:, Ne02:, Ne99: etc) the printer is on? Computers (WinXP) here at BigCorp have Adobe Acrobat (version 7.0 Pro) installed which gives a virtual printer named \"Adobe PD[详细]
2023-02-19 08:13 分类:问答Delete Empty Rows with Excel Interop
I have user supplied excel files that need to be converted to PDF. Using excel interop, I can do this fine with .ExportAsFixedFormat(). My problem comes up when a workbook has millions of rows. This t[详细]
2023-02-18 01:22 分类:问答how to attach a c# object to an excel worksheet and have it saved when the workbook is saved
I am creating an excel add-in in c#. In the add-in the user creates \'query\' objects then the query is performed and data is displayed in excel.[详细]
2023-02-16 17:46 分类:问答Can't schedule Program with Excel Interop
I have developed a console program in C# .NET, that uses Excel Interop. The program works just fine on my development machine and in the windows server 2008, if I run it from command line.[详细]
2023-02-10 13:59 分类:问答How to provide multiple choice in generated Excel file
I\'m working on an application that generates a series of Excel files where users need to enter information for school grades. One of the sections requires the user to enter a value from a selection o[详细]
2023-02-10 10:26 分类:问答myWorksheet.Range.Resize.Value = array failing at high row numbers
I\'ve inherited a large project which uses Office.Interop.Excel to insert data into a spreadsheet. In terms visible interaction, you click on a button and an Excel spreadsheet appears, with all the d[详细]
2023-02-08 07:33 分类:问答Set cell value using Excel interop
Ok, so I\'m trying to set the value of a cell with the excel interop library.I am able to do it with the following:[详细]
2023-02-06 18:56 分类:问答