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
-1
votes
2 answers

do we have any action to import entire sheet in blue prism?

Do we need to create 1000 fields in our collection, if we have thousand column in our excel sheet?
Tulal Ramesh
  • 1
-1
votes
1 answer

Excel application is not getting started using c# Winforms

My requirement is to open an excel book using c#. (ie) Am creating an excel and writing the stuffs which are needed to be entered in excel and saving it in a location .In final am showing user a yesorno box with messgae do you need to open the…
Dah Sra
  • 4,107
  • 3
  • 30
  • 69
-2
votes
1 answer

Getting IE Automation Error "Object variable or with block variable not set"

I am Getting error while automating an existing IE window. error is "Object Variable or with block variable not set" Code is Sub accessExistingIEBrowser() boolWindowFound = False Set objShell = CreateObject("Shell.Application") …
Anuj Kumar
  • 1
  • 1
-2
votes
1 answer

Does Excel Automation in UI Path support libre Office csv files

I'm trying to read contents from CSV files in UiPath. While trying to execute the workflow I'm getting the following error. But I've already installed the libre office on my PC.
Rajkumar
  • 1
  • 1
-2
votes
2 answers

how to remove two columns in excel using pandas?

Sample data: | | Unnamed: 0 | Status | Clarification Opened | Failed | |---|------------|-------------------------|----------------------|--------| | 1 | 1 | P0 Dry Run - 12/02/18 | | 2.0 | | 2…
gomathi subramanian
  • 329
  • 4
  • 14
-2
votes
1 answer

Enable the Show Formulas in Excel from C# code

I am creating a windows application in C# .net to open an excel sheet and edit it. I am using excel automation in c# to do this.After editing/modifying some values in the sheet I will save the entire sheet in text file format. I am editing only one…
user2775606
  • 15
  • 4
1 2 3
…
8
9