Questions about excel-automation
Read more about excel-automation
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Syntax is correct but showing Subscript out of range (Runtime error 9)
Not sure why I'm getting subscript out of range error on this code but as per my understandings the code is correct. This code was working fine few hours back but now getting this error. Can anyone h...
Lal Sahab
Votes: 0
Answers: 0
Getting a COM class factory Path not found exception when the path clearly exists
I'm trying to use Microsoft.Office.Interop.Excel library to convert a csv to an xlsx.
This is the function I am using
public static string ConvertToXlsx(string _sFilePath)
{
string _newFilePath = _sFi...
NortziHead
Votes: 0
Answers: 1
One opened workbook does not see other opened workbook
We have this oldschool software which opens new Excel workbook and fills it with data. It does not do anything more. The workbook stays unsaved and opened.
Now I have created a macro which looks for t...
Vojtěch K.
Votes: 0
Answers: 1
ExportAsFixedFormat's IgnorePrintAreas parameter seems not to have effect
In a Delphi application I am using since years the following code to export xlxs to pdf:
function TExportTool.ExportExcelToPDF(aFileName, aNewFileName: String): Boolean;
// reference : http://embarcad...
UnDiUdin
Votes: 0
Answers: 1