Questions tagged [excel]

Only for questions on programming against Excel objects or files, or complex formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. General help regarding Excel for single worksheet functions is available at Super User (http://superuser.com/).

0
votes
0answers
9 views

How can I automatically calculate the formulas of an Excel file made with OpenPyxl?

I'm working on an program which makes an excel file, then it gets the info into JSON and does more things. I'm struggling with Openpyxl. I found out today that if you don't open an Excel file made ...
-1
votes
0answers
7 views

Missing column when appending csv files using excel power query

I’m using excel power query to append four CSV files. Each file has the same five columns. However, the resulting combined file is missing the last column of data. Any thoughts on why this is ...
0
votes
2answers
16 views

How to merge multiple excel file via python

I have 30 excel files and want to combine them all into only 1 excel file (using Python) and i want only 1 header on top of file ( not keep happening 30 times) dont know how to write in python please ...
0
votes
0answers
12 views

HTML Question about auto loading an excel file from the server

So here is the bulk of the code (Minus other pages, the css files, other js files, basically files unrelated to the question) I am very happy with how this loads and creates the table and all of that. ...
0
votes
2answers
37 views

VBA Macro that splits data based of cell value ; and warp text

I am building a macro that splits data of based on cell value into multiple rows along with corresponding column data. Example : - cell b2 has value "G2HSB; G4ZQP" this is these are split ...
-2
votes
0answers
12 views

I need to fill the data in one xlsx file to another xlsm file using Python xlwings, Pandas, numpy ... I am new to Python

I am new to Python. I want to automate manual Excel tasks. Please help me. I have one master xlsm file and another xlsx file with multiple sheets. I am taking the values from multiple sheets in xlsx ...
-2
votes
0answers
19 views

Powershell Script - Export certain records based on a date from Excel into a .txt file [closed]

I am looking for a way to pull records from a large excel spreadsheet that are dated for specific date/or current date using powershell, If possible I would want all of the selected records to be ...
0
votes
0answers
20 views

Simple VBA to OpenOffice Basic

Im a student in france working part-time in a small business and i need help with this. I would like this code : Function SearchIn(MaChaine As String, MaZone As Range) As String Dim Result As Range ...
0
votes
1answer
15 views

VBA prefill worksheet in Excel

I'm need to create a macro (by recording that will pre-fill the spreadsheet with years in column A) so that in the cell A1 we obtain 1950, in A2 1951 and so on and so forth, until 2014. How can I do ...
0
votes
0answers
24 views

Export Excel file as HTML [preferably via VBA]

So it was finally time for me to sign up here.. (: I need to export an Excel file or preferrably a part of it to a newly created HTML file. Using VBA and PublishObjects.Add I have an export. However ...
0
votes
0answers
10 views

I have a situation in which i need to download a excel file and need to validate the data inside that sheet, if anyone know it please help me

And it should be a dynamic one, we need to download the different excel files and need to validate the data.
-2
votes
1answer
22 views

Auto clear content in column A and B everytime date changed

Every time date changed, I would like data that I keyed in to be cleared. For example, today's date is 16 Jan 22, (the date value shown in D2) then in Col A, I typed in Apple, while in the same row (...
0
votes
1answer
33 views

How to get the next matching item in row Excel

I have a table with data and I'm struggling with getting the next match data in the row. I've tried many options with no success and every time I'm getting the same solution. can someone help/guide me ...
-2
votes
0answers
30 views

Select a column in excel and has the R[-13]C[-2] stuff from macro recording in it

This is my code, but it doesn't work. Range("F17").Formula = "=IF(COUNT(R[-13]C[-2]:R[-10]C[-2])=0,10^99,COUNT(" & Range(Range("D4"), Range("D4").End(...
-1
votes
1answer
21 views

how to convert txt file to excel in python [duplicate]

I have tried to convert ".txt to .xlsx" in Python. But I still can't do it. Keep getting this error message (my text file's data is in json format.) res = conn.getresponse() data = res.read(...

15 30 50 per page
1
2 3 4 5
17121