Stack Overflow
Stack Overflow

Questions tagged [excel-automation]

Use of Excel components and functionality from code, instead of using the GUI

Excel components can be controlled by programs. VB can do it directly and actually all Excel macros are written in that language. But also, using COM-automation, you can use Excel functionality from programs written in many other languages.

126 questions
0
votes
1 answer

Generating random float number in Python

I just want to generate random float numbers between the range.But i am facing some issue This is my code import xlsxwriter import random wb = xlsxwriter.Workbook('abc.xlsx') ws = wb.add_worksheet() start = input("Enter the start value:") end =…
Someshwaran
  • 21
  • 1
0
votes
0 answers

PowerShell - Join excel files using ImportExcel

I am new to the PowerShell world, and my need is very simple. I found this utility https://github.com/dfinke/ImportExcel that meets my need but I could not find a suitable exampe But I am struggling to find an answer.Any help is appreciated My data…
Sanchu Varkey
  • 49
  • 1
  • 5
0
votes
0 answers

Find Next visible available Row in filtered data VBA

I am trying to write a program, where I must first apply the filter to Column S with 6 possible filter values (1,2,3,4,5,6). Once the filter is applied, I must copy the last used cell in column T and paste the same in the next available (blank)…
Kumar V Reddy
  • 11
  • 1
  • 4
0
votes
0 answers

Microsoft Graph workbook API - any standard way to prevent data races between multiple clients?

Scenario: Two clients on different machines read a range of cells from a shared workbook (.../drive/{drive-id}/items/{id}/workbook/worksheets/{id|name}/range(address='...'). If they both don't find the row that they are looking for, they attempt to…
kostasvs
  • 391
  • 4
  • 12
0
votes
0 answers

Unprotect sheet in foxpro

I have an xlsm file that I need to insert data but my problem is that the xlsm in protected. I use the oWorkbook.Protect(,,.F.) to unprotect but the function is not working. I s there any way to unprotect the file using the foxpro? oExcel =…
Vic
  • 457
  • 1
  • 6
  • 23
0
votes
0 answers

MS Office last updates causing some strange behavior in handling VBA code

Our admins ran some MS Office 2016 updates (Build 11929.20838) and all of a sudden I noticed a few unexpected errors in one of my previously written Excel VBA macros. For example below error is popping up against any variable which I have not…
SmIqbal
  • 99
  • 1
  • 13
0
votes
0 answers

How to copy data from One Excel sheet tab to another particular Workbook Tab Using Python

Can you please help me in copying data from a particular tab of excel sheet to another tab of excel sheet bearing the same name and data but in different workbook using Python.The workbook in which the data will be copied will also contain different…
Curious One
  • 1
0
votes
0 answers

Doc variables in Word template are not being updated from Excel VBA

I have certain ranges within an Excel file and I create an instance of Word template from within Excel VBA. This Word template has a bunch of Doc variables so that I can replace the values of those Doc Variables with my defined variables using…
SmIqbal
  • 99
  • 1
  • 13
0
votes
0 answers

Automation of Twinfield add in execution in Excel preferably using Python libraries

I have been trying to automate the process of executing the "Twinfield Analysis" add-in in Excel for quite some time. The challenge I face is that this add-in is needed to be clicked and login details need to be entered every time I reopen the excel…
Bibhu Ashish Panda
  • 1
  • 1
0
votes
0 answers

Query is not redirecting to original URL after submit Data on Webpage

I am trying to create multiple users on a web application using Excel VBA script. Below code works fine for the first row user creation but stops at set document for the second row. Actually Web app Page redirects to a different page and I think…
Ankush Kaura
  • 1
  • 1
0
votes
1 answer

Resize column width of a particular column

I need to resize excel particular column in a particular sheet.But not able to do so Sub resizeColumn(sourceWb As String, Sheet As String, column As String) Dim wkbSource As Workbook Dim sheetName As Worksheet Dim columnname As…
Nani
  • 3
  • 2
0
votes
1 answer

Using excel formula that does not overkill the file to automate process

I have an Excel dataset and I can't use any plug-ins - only Excel formulas, for the following task: There is a table: Column A, containing text labels, and Column B, containing numbers corresponding to each label (not in an ascending order). The…
Andrea
  • 3
  • 1
0
votes
1 answer

Excel IF/MID loop result showing additional data

I'm working with a fixed format text file of 100,000+ rows that I copy and paste into a sheet called DATA. All the rows in this sheet start with either AVS or AVD. I have the below code that loops through the DATA sheet with a IF MID function. I…
DJ Ragsdale
  • 3
  • 2
0
votes
1 answer

Trying to loop IF(MID function in worksheet

I have a sheet called Data that I copy and paste data from a fixed width .txt file. It's about 100,000+ rows of data that I need to loop through every row and pull data from and if it matches the criteria it shows the results on a sheet called…
DJ Ragsdale
  • 3
  • 2
0
votes
0 answers

How to register an Excel Addin COM to be used by x64 Microsft Excel (2019)

I am struggling to make a C# COM Addin visible for x64 Microstf Excel (2019). Until now my Addin is visible only for x86 Microsoft Excel, and never for the Microsoft Excel x64. My Addin (Class Library) is compiled to AnyCPU, and is very basic, i…
Chams Souidi
  • 11
1 2 3
…
8 9