All Questions
Tagged with ironpython excel
28 questions
0
votes
0
answers
65
views
Possible to copy sheet in Excel with Python API Excel.Application?
I have a small Python script that writes data to an existing Excel file.
The script is run from Ansys Workbench and in the Ansys installation python version is IronPython 2.7.4 for which Pandas (and ...
- 1
0
votes
1
answer
203
views
Header format of imported excel files into Spotfire IronPython?
I have a script that writes multiple excel files and I am trying to have another script in Spotfire that creates visualizations from these files. I am getting a "Failed to execute data source ...
0
votes
0
answers
162
views
IronPython, Python .NET (or anything else) to edit an xml table inside Excel? Openpyxl seems to corrupt the file
I have to do something really simple, and so complicated at the same time.
I have two files, one with data. like this:
file1
And the other one is a template, with an xml table headings on A3 and the ...
1
vote
1
answer
2k
views
How to load an excel file in IronPython?
I am trying to load an excel file within an IronPython script, which is embedded within a software.
I tried to do this with the following code:
import clr
clr.AddReference("Microsoft.Office....
- 17
0
votes
1
answer
982
views
Script to take data from excel to Ansys for applying pressure value
I have excel tabular data of force for different faces/locations. I wanted to create the pressure tab in Ansys workbench and apply force data from reading cells from excel, but it shows following ...
0
votes
1
answer
343
views
Add image to excel worksheet using Interop and Iron Python
What is the best way to add images to an excel workbook using Iron Python and Interop only? I can't use any custom excel packages. I can get this method below using Shapes to work but its limited in ...
0
votes
2
answers
168
views
Can't detect if the excel file is open without prompting user to save file / cancel
Using Iron Python I need to first determine if the excel file is already open and then if it is open, access it. if its not open then open it. problem: in my try statement when I try to open the ...
1
vote
0
answers
290
views
Spotfire excel export with merged cells
I am using iron python script to export Spotfire crosstable to excel ouput.
Before exporting i am adding headings and then table content. while adding a haading is there a way to merge cells and ...
1
vote
0
answers
70
views
Creating Dictionary from Excel file in IronPython
The only main difference between IronPython and Python, is basically I can't use pandas in IronPython.
I have an excel spreadsheet where I want the first column to be the keys, and the second column ...
4
votes
3
answers
5k
views
Ironpython write to Excel
I am trying to write data from Revit to Excel with RevitPythonShell.
So far I have collected all data in a zipped list and made an enumerated for loop to write the data to the corresponding rows and ...
- 119
2
votes
1
answer
998
views
Cancel Excel's close event using python and win32com
Currently I try to cancel Excel's close event using Python and win32com. I have already managed to handle this issue with IronPython some month ago. But for further purposes of my companies department ...
- 301
1
vote
1
answer
2k
views
Run a VBA macro in Spotfire using Ironpython
So I would try ask over in this thread IronPython - Run an Excel Macro but I don't have enough reputation.
So roughly following the code given in the link I created some code which would save a file ...
- 31
0
votes
1
answer
826
views
How to get excel range topleft and bottomright cell in en Excel worksheet.
I would like to find the topleft cell and bottomright cell in an Excel worksheet range, which is a bounding box of all occupied cells in the sheet, from ironpython 2.7.5 on win 7.
My code:
from ...
- 335
2
votes
0
answers
73
views
Close SharePoint pop-up window from python
I have a python script which works with a SharePoint library. It takes Excels documents which are in the library, reads in the read-only mode the information and closes the documents.
The problem ...
0
votes
2
answers
837
views
How to change color of a cell in Excel file with Iron Python?
How do I change cell background color in Excel from Iron Python?
I tried following code:
def rgb_to_hex(rgb):
strValue = '%02x%02x%02x' % rgb
iValue = int(strValue, 16)
return iValue
...
- 95