All Questions
Tagged with excel visual-studio
531
questions
0
votes
1
answer
123
views
Getting error for COM excel when trying to build project in Visual Studio
Using Bitbucket as remote repo.
Created a Https token in bitbucket
When trying to clone using Visual Studio it asked for username and password. I provided with my username and for password gave the ...
0
votes
0
answers
26
views
After exporting the SSRS report to excel which has totals, Can we again recalculate the values of total by deleting any row in excel
I created a report in visual studio and the report has total of many columns. I need to export the report to excel and then If I delete any row from the excel sheet the excel should automatically ...
0
votes
0
answers
34
views
Automate macros in excel using python
I want to automate adding a macro in Excel files using a python code written in Visual Studio
How should I do that?
What should be the code like
import win32com.client
def add_macro_to_excel(...
-1
votes
1
answer
399
views
How to get handle on an open excel file in vb.net with .net 8.0.2.?
I am using vb.net and .net 8.0.2. App is running on Windows 11.
I have been trying for hours to point to an excel file which has already been opened by the user.
I tried:
Dim app_excel As Microsoft....
1
vote
2
answers
113
views
Error 0x80042001 when Using VSTO Excel Spreadsheet
I get this HRESULT 0x80042001 error everytime I try to use VSTO to code for Excel Spreadsheet.
It will not load. I've tried several things such as uninstall VS and MSO, used cmd to fix issues, ...
0
votes
1
answer
27
views
Configuring Excel File for Automatic Content Activation
I'm currently working on an Excel file that includes external links to my CUBE. Within my cube, there's a Row-Level Security (RLS) function implemented to ensure that a manager can only view data ...
0
votes
0
answers
81
views
(Excel Source) File Processing SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005
We are using an excel connection to process files in SSIS (Visual Studio Community 2017) and the process was running well into all of it sudden it stopped processing our files. We have disabled the ...
0
votes
1
answer
50
views
Saving workbook, How to not deal with popups?
I am trying to update data in a excel file. I can open a workbook and add my new data. When I close the workbook it fires a thread that has a pop-up below all other pages asking if I want to save the ...
0
votes
1
answer
251
views
getting an excel extension because the old extension is no longer working when downloaded
I have a code similar to this below
using(webclient wc = new WebClient())
{
string fileinfoname = "test_one";
string pathinfo = @"C:\testfolderinfo" + fileinfoname + ".xlsx&...
0
votes
0
answers
136
views
Import and store multiple Excel Files in multiple folders to SQL Server table using SQL Server Integration services
I have multiple Excel files (Ms. Excel 2019) in multiple folders that I want to import and store the data to SQL Server table. I want to build a data warehouse for Power BI dashboard and choose SQL ...
0
votes
1
answer
24
views
SSIS, create file excel with Getdate()
i want to create an excel file with File System Task in ssis and that in the new excel file be saved with the current date
0
votes
0
answers
406
views
Microsoft.Office.Interop.Excel ''System.__ComObject' does not contain a definition for 'Value''
Just trying to get this to work at all.
In my .csproj:
<ItemGroup>
<COMReference Include="Microsoft.Office.Interop.Excel">
<WrapperTool>tlbimp</WrapperTool&...
0
votes
1
answer
315
views
in C# using Microsoft.Office.Interop.Excel Is there a way to collect the data from a row without looping through each cell of the row?
I'm trying to collect the data from each row of an excel worksheet and turn it into a coma-separated string for comparison using a dictionary.
I'm looking for a way to collect each row's data without ...
0
votes
0
answers
119
views
SQL Server query result to Excel file
On Visual Studio, I have created a data flow task with OLE DB Source and Excel Destination.
Currently, data flow works fine but data formatted as numbers in database is copied as text in the Excel ...
0
votes
1
answer
105
views
How to add a progress bar to windows form which shows dynamically how much process is completed
I am working on a Windows Form in Visual Studio.
The form takes 2 excel files (say A.xlsx und B.xlsx), processes them and produces "n" number of files at the end.
The "n" is always ...