Tagged Questions
-5
votes
0answers
17 views
cancel pivot table refreshing in C# [closed]
Could I cancel pivot table refreshing in C#?
I found there are 2 Event Handlers may related;
SheetPivotTableUpdate
WorkbookPivotTableOpenConnection
But there is no Cancel Property.
Any ...
0
votes
0answers
25 views
Set an Option button's value on Excel using Interop on VB
I'm importing a library to modify cells in Excel:
Imports Excel = Microsoft.Office.Interop.Excel
I'm using this line to modify the value of a cell (oWs being the sheet):
...
-1
votes
2answers
41 views
“Close” Button of programmatically created Excel doesn't kill the process Excel.exe
Good day everyone, I've got a rough question for you.
I've programatically created an excel document using Interop.Excel and when I close it programmatically process EXCEL.EXE has been killed. BUT, ...
1
vote
1answer
46 views
C# Excel interop: Exception from HRESULT (DISP_E_BADINDEX)
I'm trying to deploy an application that works fine on my development pc and some other workstations.
However, some users receive an error that I can't seem to grasp.
The program is a C# dotNet app ...
0
votes
2answers
46 views
Querying xml parent node attribute from child node
I am working with an xml similar to this:
<?xml version="1.0" encoding="utf-8"?>
<Results>
<Pattern Name="Substitution">
<TestList>
<Test>
...
0
votes
0answers
23 views
Excel Missing image in file generated by IIS
i build application which use Interop Excel to generate excel. When i launch this application manually on my local machine its fine. when task scheduler runs it on the server with administrator rights ...
1
vote
1answer
36 views
C# Excel (2003) interop - Margins don't correspond to the input value?
I'm using dotNET C# to communicate with Excel 2003.
I'm trying to change the print margins of the document, but the values that I put in, don't correspond to the margin values that Excel then uses...
...
0
votes
1answer
48 views
Excel Interop - Copy a filtered worksheet to a different Excel instance
Suppose I have the following Excel Interop objects declared:
Dim ExcelToKeepHidden As New Microsoft.Office.Interop.Excel.Application
Dim SheetToCopy As Microsoft.Office.Interop.Excel.Workbook
...
1
vote
1answer
68 views
C#: State of a Checkbox in MS Excel
I am trying to acquire state of a checkbox existing in an XLS document via C#. Let me back up here. This is what I have:
MS Office 2007 + Dev Tools and VC# 2010 Express
Referenced MS Excel 12.0 ...
0
votes
1answer
134 views
Check for installed Excel version, then load COM object library dynamically in C#
I am using Microsoft.Office.Interop.Excel to write data to an excel file in C#. I am using Excel 2010, so I have Microsoft Excel 14.0 Object Library added as reference.. But now I need to make the ...
2
votes
0answers
66 views
Checking for Excel dll and loading dynamically
I am using Microsoft.Office.Interop.Excel for writing data to an Excel file, I have Excel 2010 installed on my machine. But I need the program to run on older versions of Excel..
The program should ...
0
votes
0answers
68 views
Exporting Collection of Trends: Excel -> C#
I encountered a problem of working with Excel trends and transferring them. It's easy to work with usual things like formulas/values, because these things might be exported into csv file, but I can ...
0
votes
0answers
156 views
Error when attempting to set pie chart title using C# Excel Interop
I am creating an Excel pie chart using Excel Interop. The chart is being created correctly, however when I go to set the title, I get a runtime exception that states: "This object has no title.".
...
-5
votes
6answers
341 views
C# win form app not working outside rar file
I have really strange 'bug' that i don't have a clue what it might be about.
App is made with VS2010 using .net 4 frame. Beside normal assemblys, it uses MS interop for excell. I have Office 2010 ...
3
votes
2answers
6k views
Excel get_Range missing when interop assembly is embedded in .NET 4.0
I build an assembly referencing a COM interop DLL. If I embed the COM interop types by setting Embed Interop Types to True in the Reference's properties (VS2010), at run-time an error occurs "object ...
