All Questions
14,034
questions
0
votes
0
answers
46
views
Passing an array of objects from C# to VBA Excel
I have a C# console application and Dll. I registered the dll as COM via interop. I used the
COM Visible property, GUID etc
Set Assembly Information, Build information to register it to COM
I ...
0
votes
0
answers
27
views
Uploading file to ASP.NET Core Web API using VBA
I'm struggling to upload a CSV file from local drive to a Web API.
Sub Upload()
Dim objHTTP As New MSXML2.ServerXMLHTTP60
Dim url As String
Dim filename, resp As String
Dim boundary, ...
0
votes
0
answers
21
views
Getting extra null rows when I am trying read excel file with EPPlus OfficeOpenXml
I have an Excel file with 4 sheets. However, it is behaving incorrectly when I am reading the first sheet in my C# (.NET Core 3.1) code.
The sheet has around 350-450 entries, sometimes it reads only 4 ...
0
votes
1
answer
40
views
I am using C# to display results in Excel. Its showing Compile Error CS1061
Code will open a new Excel file (visible = False) and data will be entered then the Excel file will be made visible (visible = True).
using oExcel = Microsoft.Office.Interop.Excel;
private void ...
1
vote
1
answer
98
views
+100
How to sign Excel file programmatically in c# application
I have some long-existing code that uses Microsoft.Office.Interop.Excel.Application to manipulate Excel files, and then serves those files to client browsers in response to HTTP requests. This ...
0
votes
1
answer
34
views
How do binding redirects currently work for ExcelDNA plugins?
I am currently stuck in dependency hell with an Excel DNA plugin that uses the Azure SDK to talk to a blob store.
I am encountering the issue outlined here https://github.com/Azure/azure-sdk-for-net/...
0
votes
0
answers
26
views
EPPlus Pivot table date grouping not formatting correctly
I have a pivot table created using EPPlus. The data is basic sales information, with a date, item name and total.
The Pivot table contains the name and date in the row with total summed. It also ...
-2
votes
0
answers
66
views
Passing a HashTable argument to an Excel VBA function with Collection parameter
We are migrating VB6 code that uses Excel VBA functions for some operations to C# .NET. I do not have much experience with VBA, VB6 or Interops.
I can call a VBA function that has a string parameter ...
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
18
views
ExcelWriter throws TypeInitializationException when trying to run the AutoFitWidth function
SoftArtisans.OfficeWriter.ExcelWriter has the capability to create a worksheet area based on a number of columns. This works, however, when I try to AutoFitWidth() of the Area I receive this error: ...
0
votes
1
answer
61
views
Modifying linked IFC in Revit using C#
I'm working on an automation project in Visual Studio using C#, but I still have limited experience and lack a lot of knowledge. revit errorThe script manage to download the IFC file and reload it ...
0
votes
0
answers
21
views
How can I convert a Pivot table in Epplus to a normal table in C#?
I am using Epplus to export some data into an Excel spreadsheet. For one sheet, I made a chart using that data and it works just fine. For another sheet of data I also need to make a chart, but in ...
0
votes
1
answer
25
views
ClosedXML (Ver 0.102.2): Setting horizontal alignment not working
I am trying to set horizontal alignment of cells when exporting data to excel. Cells with numbers should align right.
What I did:
First creating the table:
var table = CurrentWorksheet.Range(1, 1, ...
0
votes
0
answers
31
views
Read data from the table, find the necessary user variable, and display it on the screen. ClosedXML
I'm still quite new to programming and I started with C#. I want to make a simple application that accepts an error number from the user, for example: "F_220". Read data from the table, find ...
-1
votes
0
answers
121
views
Bloomberg Excel API never ending "#N/A Requesting Data" problem
I have a C# code that automatically inserts a Bloomberg formula into an Excel-Worksheet cell and applies this formula to the entire column. When I run this code, the Excel workbook opens, and I can ...