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

Obtain text from Excel Name Box Using C# and WinAppDriver

I have an automation project in C# that works with Microsoft Excel using WinAppDriver Release Candidate 1.2. I have a case where I am attempting to get the number of rows that have been populated on a sheet with the code below. public string…
Lee Z
  • 802
  • 2
  • 13
  • 39
0
votes
1 answer

Force addin load in Excel /automation

I have an Excel Automation addin providing a set of UDFs. I want to get those UDFs working even when opening Excel via the Interop APIs. I know that when opening Excel via the Interop APIs Excel is started with the parameter /automation which makes…
Patrick Böker
  • 3,173
  • 1
  • 18
  • 24
0
votes
1 answer

Using win32.com to copy excel worksheet throws Microsoft Excel copy paste error

When I use win32.com to open an excel file and paste the sheet into another excel file i get a copy paste error. import win32com.client import os excel = win32com.client.Dispatch("Excel.Application") w =…
Jeffyx
  • 78
  • 2
  • 9
0
votes
2 answers

Load sheet in an excel file and save it to another different excel file

Using python 3, I'm trying to append a sheet from an existing excel file to another excel file. I have conditional formats in this excel file so I can't just use pandas. from openpyxl import load_workbook final_wb =…
Jeffyx
  • 78
  • 2
  • 9
0
votes
1 answer

"show formulas" in excel using python & win32com

How can display/show all of the formulas in an Excel workbook using Python3 and win32com.client, like I can do interactively with Cntrl-` I believe I have to use the Windows DisplayFormulas Property but I don't know how to access the ActiveWindow to…
Levon
  • 138,105
  • 33
  • 200
  • 191
0
votes
0 answers

Mutiple auto pivots by a button (VBA)

I am trying to achieve the goal of automating a support template. The function I am working on is creating a button or drop down selection button that will auto pivot from the excel table to the desired pivot tables. The code below is creating a…
FinanceGuy
  • 15
  • 10
0
votes
0 answers

What would be the most efficient way to automate excel reports with lots of columns to send out via email?

I need to send via email multiple excel reports with approximately 60 to 100 columns. Currently I am using SSRS to render it to excel and send out via emails. But is there any more efficient way maybe? Data generated by stored procedure in SQL. …
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
1 answer

Fix csv files through Excel/Numbers [automatically through Python]?

I'm working with some CSV files which have been created incorrectly. There are quotations and commas interconnected, and I keep getting parsing errors from pd.read_csv, even after replacing all column-separating commas with tabs. Nevertheless,…
Nico
  • 311
  • 4
  • 11
0
votes
0 answers

why the hash-table error is shown while filtering by date using pandas?

I don't know why i'm getting the keyerror: 'Tested On' msft = pd.read_csv("C:\\Users\\gomat\\Desktop\\Py TR\\week_06.csv") msft['Tested On'] = pd.to_datetime(msft['Tested On'],dayfirst =True) msft = msft[msft['Tested On'].dt.floor('d') ==…
gomathi subramanian
  • 329
  • 4
  • 14
0
votes
2 answers

How to automate excel task

This is an example excel data I am using. I have to lookup address age and preferred location with 7-8 different file every morning. This is an example of the date which I receive to fill up. | Unique No.| Name | Address | Age | Preferred location…
Elisha Robert Joseph
  • 23
  • 1
  • 7
0
votes
2 answers

How to To Loop through cells in a column, and to find the latest date of the list in Excel VBA

Actual work to loop through the Column A which has same value of with certain range, with that range have to check the latest date with the comment in Column B and print the comment with date in Column C kindly help me to find the solution for this…
Bharath Babu
  • 65
  • 2
  • 8
0
votes
0 answers

How to scrape data from newly opening webpage?

To scrape data from webpage which is opening after clicking a submit button In this website I'm filling textbox showing place-holder #Tracking with this value 148459 after filling clicking Submit it opens another page, with details... I want to…
Bharath Babu
  • 65
  • 2
  • 8
0
votes
1 answer

How to search (TRUE/FALSE) for a term from a list of websites?

I have a column of URLs in an Excel spreadsheet. I'd like to enter a word somewhere (a cell off to the right or a dialog box) and have Excel search all the URLs in the column (or a subset of them) for that term. It should work in the background,…
Nick Georgopoulos
  • 13
  • 3
0
votes
1 answer

Visual Studio C# Properties.Settings.Default issues

The issue I'm running into here is that I am building a combined COM and Automation Add In for Excel. When trying to access Properties.Settings.Default in the Automation Add In class I have created, the values coming through are the ones I have set…
Aaron
  • 167
  • 1
  • 10
0
votes
1 answer

How to delete the visible rows after Auto Filter , excluding the heading row?

In Excel Interop, after setting a Range.Autofilter(), then I need to delete all visible rows except the first row. Since the first row is the heading row of the sheet. Thanks .
Gokul
  • 788
  • 2
  • 12
  • 30
1 2 3
…
8 9