excel

Hello, I am unable to save a workbook that i created when i use the functionality, for ex Today() for the filename parameter. This is how i created the excel first: Create instance > Create Workbook > Activate Workbook > Save WorkBook as ( this has 3 parameters (handle, workbook name and file...

Hello, I have a collection of 20,000 rows and I can´t write them in an excel, I don´t know how to write it by code or if there is some other way, thank you.

I have an Excel workbook where is needed to remove all rows wherever appears a 0 value in a certain column before adding it into a collection (see attached picture as an example: When column D contains 0 value, that row must be deleted). I tried these actions with MS EXCEL VBO 1.Get Cell value...

I need to be able to create a pivot table from a selected range, manipulate the style, filters, data, etc. It would a great help if someone could clarify this for me. Thanks!

Hi guys, I have a process scheduled to run every 30 min which uses a macro to query a SQL entry from database. Yesterday I got unexpectedly an error "Excel is waiting for an OLE action to finish" From what I googled it looks like "Object Linking and Embedding action" is pending with another...

Hi, is there any way to hide the column in excel sheet? ex : i have 5 columns in collection.( A,B,C,D,E) In column E, i have to hide and save. i should not delete.It may use after sometime, to check that hide column. Is there any way to hide column & save the excel.

Hi, I have this requirement where I need to "Paste Special" as VALUES some of the content that I have copied from one sheet. Any idea how to achieve this? Regards, Arjun Sehrawat

Hi , Does anybody knows that if posibble to change the color of one row in Excel with AA ?

Trying to read an excel file, facing this issue. Please help. Facing this error, for Action - GetWorksheetAsCollection. Always last column is having issue. Pls help

i am all over sudden getting this weird exception. this seems to be happening when closing excel. This is the error attached. "System.runtime.iteropservice.InvalidComObjectException: COM object that has been seperated from its underlying RCW cannot be used at...

Is there any way to get the row and column count in an Excel. Kindly provide some solution.

Hi everybody, I'm trying to insert a pie chart into excel worksheet. For this sake I recorded a macro and used its code in Code Stage in the Excel VBO. Here's what my code looks like after the modifications for use in BP: Dim wb as Object = GetWorkbook(handle, workbookname) Dim ws as Object =...

Thats the message what i get if i am starting my process. I attached also a screenshot. Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation. Please help me out by that problem! Thank you very much.

How to Paste an image from clipboard to Excel on a particular cell?

Hello, I'm new here. Can I ask if it's possible to have Excel values created as separate data items? Let's say I have a column of data item names and another column for its values. Also, if that's not gonna work, is it possible to create data items if I fetched the data to a collection first...

Hi All, I have the next problem. I have a collection with more than 15K rows and I need to write it in excel, but the problem is that it takes a lot of about 40 minutes with the Write Collection (Excel VBO) object, can the execution time be shortened?

I am trying to create an organizational structure, based on excel data. I am unable to do so. Help needed. The input is in two columns like this, EmpID | MgrID 1 | 4 2 | 4 3 | 4 4 | 5 5 | 8 6 | 4 7 | 4 8 | 10 9 | 10 10 | 11 11 | 13 12 | 11 13 | -

Hey guys! I am trying to extract values from an excel spreadsheet and storing it into a dynamic data structure. Could someone please help me find a solution similar to how a dictionary key/value pair mapping would work? Reply asap please :confused:

Hi, i need convert a collection a excel file... How do I do it?

How are you guys opening Excel files stored in SharePoint? We have a standard object for opening Excel files and when we put in the local network path for the SharePoint file it will not open consistently. If we have already accessed the file on that computer it will open no problem, however...