Stack Overflow
Stack Overflow

Questions tagged [pyexcelerate]

PyExcelerate is a Python package for writing Excel-compatible XLSX spreadsheet files, with an emphasis on speed. It is not to be confused with the older pyExcelerator package.

PyExcelerate is a Python package for writing Excel-compatible XLSX spreadsheet files, with an emphasis on speed. It is not to be confused with the older pyExcelerator package. https://github.com/kz26/PyExcelerate

15 questions
4
votes
2 answers

Pyexcelerate freeze panes

XlsxWriter has a method of adding frozen panes to an excel file: import xlsxwriter workbook = xlsxwriter.Workbook('frozen_panes.xlsx') worksheet1 = workbook.add_worksheet('Panes 1') worksheet1.freeze_panes(1, 0) However, I have to use…
jonesne
  • 191
  • 10
3
votes
1 answer

Append in exisitng excel sheet using PyExcelerate

I have a dataframe containing large number of records (more than 300,000 rows and 100 columns) . I want to write this dataframe into an pre exsiting excel file (say Output.xlsx). I tried this using openpyexcel as below- with…
Rahul
  • 31
  • 2
1
vote
1 answer

Negative Number formatting with pyexcelerate in python

I have a requirement to write an excel sheet from python with some number formatting. We need to format a -ve number with brackets and in red font. -1.2 to be formatted to (1.20) with color red. Initially, I tried achieving it by converting it into…
Johnson Francis
  • 249
  • 3
  • 17
1
vote
1 answer

Pyexcelerate: set table style format

I am using below code to export DataFrame to excel using pyexcelerate: from pyexcelerate import Workbook ''' code to populate DataFrame ''' excel = [df.columns] + list(df.values) wb = Workbook() wb.new_sheet('Sheet1',…
Karthick Raju
  • 757
  • 8
  • 29
1
vote
1 answer

Adding Image in excel using pyexcelerate

I am using pyexcelerate library to generate an excel sheet in python. I need to add an image at the top using an image url but I could not find any solution for that library. Can anyone tell whether its possible to add image using pyexcelerate?
John Doe
  • 11
  • 3
1
vote
1 answer

Dataframe print index using pyexcelerate

How do I get to display index on my output excel sheet? Here is my code: data = [df.columns.tolist(), ] + df.values.tolist() wb = Workbook() wb.new_sheet("sample", data=data) wb.save("output.xlsx") How do I show index as the first column? I was…
misguided
  • 3,699
  • 21
  • 54
  • 96
1
vote
1 answer

Batch writes in excel using Python PyExcelerate

I am trying to speed up the process of writing data to an excel file using python in my code. The PyExcelerate module has a good benchmark in terms of writing bulk data to files compared to other python modules. Dimensions: Rows = 10000 Cols =…
Vaulstein
  • 20,055
  • 8
  • 52
  • 73
0
votes
1 answer

"File size unexpectedly exceeded ZIP64 limit" while saving excel workbook

I am trying to create an excel sheet with large data and save it to the disk. I use pyexcelerate module as it is faster than others. I also do some styling. So, converting to csv is not an option for me. As the excel sheet is large, it is giving…
Johnson Francis
  • 249
  • 3
  • 17
0
votes
0 answers

Effective way to write a large excel file with multiple tabs which has heavy cell formatting and coloring

I have a requirement to create an excel sheet with multiple tabs. I could do it with pandas and openpyxl def write_to_excel(file,sheet,dfM,mode='a') : # Remove dup columns from dataframe if any. dfM=dfM.loc[:,~dfM.columns.duplicated()] …
Johnson Francis
  • 249
  • 3
  • 17
0
votes
0 answers

Is there a default alignment option on openpyxl just like on xlsxwriter?

I've been using openpyxl and xlsx for few months and have found while there is an option to change the default alignment format on xlsxwriter, there is none on openpyxl. More details: Xlsxwriter - creating an .xlsx with xlsxwriter, defining default…
yahel
  • 1
0
votes
0 answers

pandas bool type to yes or no

I am dealing with nearly 100000 rows of data so I am using pyexcelerate to write excel file through the dataframe. When I was using pd.ExcelWriter(path) i was able to map a bool field of pandas to yes or no but now using pyexcelerate i get #NUM! in…
satyam singhal
  • 3
  • 8
0
votes
1 answer

python: writing data to excel file but "cannot close file"?

so I have this pandas data table that I wish to write into an excel workbook. I'm using pyexcelerate package. Here's my code: from pyexcelerate import Workbook def df_to_excel(df, path, sheet_name='Sheet 1'): data = [df.columns.tolist(), ] +…
alwaysaskingquestions
  • 1,595
  • 5
  • 22
  • 49
0
votes
3 answers

Python pyexcelerate library writing multiple sheets to same workbook?

I am trying to write multiple sheets into one workbook and I'm using pyexcelerate to utilize it's optimized writing time. Here's my current code to write to a workbook: def df_to_excel(df, path, sheet_name='Sheet 1'): data =…
alwaysaskingquestions
  • 1,595
  • 5
  • 22
  • 49
0
votes
1 answer

Writing special chäracters with pyExcelerate? How to keep utf-8 encoding?

I want to write data from a Pandas dataframe to an Excel file. I am using pyExcelerate rather than the built in to_excel() method to get better performance. While Pandas handles utf-8 encoded special characters, the encoding seems to be lost when…
malte
  • 559
  • 1
  • 8
  • 25
-1
votes
1 answer

How to get a django file instance from pyexcelerate workbook?

I have recently checked the pyexcelerate to help improve the performace of exporting a pandas data frame to excel file i have the following code values = [my_df.columns] + list(my_df.values) wb = Workbook() wb.new_sheet('outputs', data=values)…
Mohamed Ibrahim
  • 195
  • 1
  • 2
  • 8