excel-interop
Microsoft Office Excel cannot access the file 'c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx'
I have my code as follows :- Microsoft.Office.Interop.Excel.Application oXL = null; Microsoft.Office.Interop.Excel.Sheets sheets;[详细]
2023-03-29 13:29 分类:问答HRESULT: 0x800A03EC on Worksheet.range
I am getting HRESULT: 0x800A03EC on Worksheet.range method. Number of rows are more than 70K. Office 2007.[详细]
2023-03-29 08:47 分类:问答converting object to two dimensional array in C#
This one should be simple, but I don\'t really know how to find a way to do it... I am using .NET 4.0. I have an object[12] filled with decimal numbers, and want to use it to fill an Excel range of D[详细]
2023-03-24 05:08 分类:问答How to I bind EXCEL range in VBA macro from a C# Library that returns object[,]
I have a C# library which has 2 methods. One returns an Integer and another returns a object[,] public int ReturnInt()[详细]
2023-03-21 18:34 分类:问答Retrieving excel sheet cell value
I am usi开发者_运维知识库ng c# to read the value of particular cell of excel sheet. But as per my code I am not getting any value..[详细]
2023-03-18 02:57 分类:问答FormatCondition Font Bold from C# Excel Interop not working
I\'m adding a new FormatCondition to a cell and trying to set som开发者_如何学编程e formatting:[详细]
2023-03-14 13:10 分类:问答Excel Get_Range with multiple areas
I\'m trying to get a range from Excel开发者_运维技巧, which has multiple areas specified, essentially I\'ve got...[详细]
2023-03-09 06:19 分类:问答Excel Interop: reference by number, not by string
Good morning. After having read the answer on a question about optimizing Excel Interop, I found that referencing a cell using worksheet.Range[\"A1:C3\"] (same as worksheet.get_range(\"A1:C3\")) isn\[详细]
2023-03-07 14:02 分类:问答DragDrop on new Excel Sheet gives "Object reference not set to value"
I am using devExpress. Office 200开发者_开发知识库7. c#. When I drag and drop my results in 1/2/3 excel sheet works fine, but dropping results on new sheet gives Object reference not set to an instanc[详细]
2023-03-01 22:02 分类:问答Excel Template: Merging data and saving workbooks
I am on my first foray into Excel Interop and after a flying start have hit a wall. I have an Excel template that contains one sheet which is an assessment form and another which contains guidance no[详细]
2023-02-24 05:40 分类:问答