I need help in converting a .xls file to .xlsx using C# and without using Microsoft Office.
Hello I am just trying to get into a bit of macro programing to help my Mom, and Dad get some excel work done, and they have some ungodly amount of paper work i
I am still relatively new to Java and have cobbled together enough code that allows me to write my data out to a new excel file. However, I want it to write (a
I am wanting to write a C# program to copy a specific range of cells below a specific keyword. The code will identify a keyword in Excel and then copy the value
I'm working on a rec process which will pull data out of a SQL Server database into Excel and out of another application to compare the two sources. I've writt
So I have an Excel document, which is essentially a table. For the purposes of this, we will use this: Dummy Data What I'm wanting to do is take the values fr
I have a large xlsx Excel file (56mb, 550k rows) from which I tried to read the first 10 rows. I tried using xlrd, openpyxl, and pyexcel-xlsx, but they always t
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
my application basically accepts an excel file and uploads data to my database which used to work perfect with Excel 2010 with the below code. However we update
I am working on a tool to analyse data. The data to be analyzed is manually copied into the first sheet, then I am planning to run a macro which analyzes the da
I am receiving a null pointer exception when trying to launch an instance of excel to export data to. I have tried adding the newest version of COM4J.jar to my
I have an excel template that has preset formulas, then have my wpf application fills in data in other sheets then the preset formulas takes the data from the o
With xlwings, I am trying to move a worksheet within a workbook to the end. For example, a workbook contains a collection of the following she
Is there a way to have a macro changed when the value is changed is changed, not necessarily when a user changes the value? For example, I have a check box th
The user has hundreds of text files and requires making a change in the data before saving and closing them. Below is the code I have for a single file; how can
I would like to use this string as a date time in excel 2016-04-06T18:05:32.6550717+03:00 How can it be converted?
When running the XIRR function "=XIRR(G163:G168,F163:F168)" where the cashflow is in G163:G168 and my dates are in F163:F168, excel is returning a value of .000
I am writing codes to export database from R into Excel, I have been trying others codes including: write.table(ALBERTA1, "D:/ALBERTA1.txt", sep="\t") write.cs
I have a model that produces an array of values that can be several hundred columns wide. Every 25th column contains a number that I need to add to the total. I