Stack Overflow
Stack Overflow

Questions tagged [spreadsheet-excel-writer]

A PHP package for generating Excel spreadsheets

From its PEAR page:

Summary

Package for generating Excel spreadsheets

Description

Spreadsheet_Excel_Writer was born as a porting of the Spreadsheet::WriteExcel Perl module to PHP.
It allows writing of Excel spreadsheets without the need for COM objects.
It supports formulas, images (BMP) and all kinds of formatting for text and cells.
It currently supports the BIFF5 format (Excel 5.0), so functionality appeared in the latest Excel versions is not yet available.

32 questions
10
votes
2 answers

Handle Nan when using Pandas ExcelWriter in python

How would I change the following code to handle NaN values as just empty cells within my dataframe as I iterate through it line by line outputting values in column A? excel = pd.ExcelWriter(f_name,engine='xlsxwriter') wb = excel.book ws =…
Mike
  • 197
  • 1
  • 2
  • 10
5
votes
2 answers

Set the color for a specific word in a Excel cell using Spreadsheet Excel Writer php

I am trying to set the color for a specific word in a cell using Spreadsheet_Excel_Writer but did not found any way in the documentation. I have to set the red color for the first word of a cell but not for the whole text in it. Is there a way to do…
Shakti Singh
  • 84,385
  • 21
  • 134
  • 153
3
votes
2 answers

delete first column when exported excel or csv file in python

let's say, I exported my file in excel statement Export ln[] = writer = pd.ExcelWriter("df2018.xlsx") writer = pd.ExcelWriter("df2018.xlsx", index = false) df2018.to_excel(writer) writer.save() out[] = row0 (blank) kanwil jan 2018 feb 2018…
Charisma Bathara
  • 69
  • 1
  • 8
3
votes
2 answers

PYQT4 not able to write into excelwriter

I have a gui I created in pyqt4 that has a function to call a module that is supposed to write into an excel sheet using pandas excelwriter. For some reason, it creates the worksheet but does not write anything into it. It just crashes my qui…
Daniel
  • 77
  • 3
  • 20
3
votes
1 answer

How to change the format of dataframe output when using pandas to_excel with ExcelWriter and xlsxwriter

I am using Python 3.4 on Windows. Functionally, I have no problem using pandas to write a dataframe named "df" to an Excel xlsx file this way: import pandas as pd import xlsxwriter writer = pd.ExcelWriter('Test Data\simple.xlsx',…
Alan G.
  • 61
  • 4
3
votes
1 answer

Loop not writing correct values

I have a table that contains all the employees in a company (hr_employees). In addition to this table, is another table that has all their start dates and end dates, plus which type of contract they have (hr_employees_status). With the data I get, I…
Bird87 ZA
  • 2,313
  • 8
  • 36
  • 69
2
votes
1 answer

How add new colum in existing excel using xlsx writer in python

I need to add a new column in my existing excel sheet which is .xlsx using Excel writer in python. Name |sub1 |sub2 |sub3. Ram. |10. |20. |30. Raja.| 11. | 22. | 33 I need to added new columns for TOTAL and AVERAGE and need to calculate it and…
RSD
  • 27
  • 4
2
votes
1 answer

How can I concatenate symbol ("%") to integer value in python?

I am facing an issue here. I have a Dataframe column whose values I need to put as value+% i.e. say 10%, 15% etc. However, I am able to put the values as string type in the excel sheet after writing but while I plot the graph, the value is being…
Sandeep Puppala
  • 65
  • 1
  • 8
2
votes
0 answers

PEAR Excel Spreadsheet Writer - writeURL()

I am trying to port a system from PHPExcel over to PEAR's Spreadsheet_Excel_Writer. When I make more than 23 calls to writeURL I get a corrupted spreadsheet. I have beaten my head against a desk trying to solve this. Below is a small, stand-alone…
someguy
  • 21
  • 3
2
votes
2 answers

Why does the fillment of a bar chart in Excel::Writer::XLSX not work?

I create an excel sheet including a stacked bar chart. Now I want to have no color in the first bar, but it is still blue. Code looks like this: $chart->add_series( categories => [ 'Sheet1', 1, $counter, 0, 0 ], values => […
user1665139
  • 21
  • 1
2
votes
4 answers

PHP Excel Writer Wrap text

I'm using this plugin, I know it's not the best, but I don't have time to rewrite all these scripts. I need to know how enable text wrap. The incomplete documentation on the website doesn't help at all. I have tried using 1 and 'wrap' as the…
Bird87 ZA
  • 2,313
  • 8
  • 36
  • 69
2
votes
2 answers

File is not readable with Excelwriter and phpExcelReader 2

I use Excel Writer of Harish Chauhan to generate an excel (xls) file. Then I use phpExcelReader 2 to read the file created by the Excel Writer class but have this error all the time : The filename myXls.xls is not readable I can open the "myXls.xls"…
Nấm Lùn
  • 1,277
  • 6
  • 28
  • 48
1
vote
2 answers

can I modify worksheet's title after "adding" this worksheet to workbook in spreadsheet_excel_writer?

the problem is that I cant set Worksheet::setInputEncoding to a worksheet that isnt created, but I need to set name in utf=8 format to this worksheet. so for now I got this result: some unreadable symbols in worksheet title. any suggestions?
Anthony Dev
  • 103
  • 1
  • 6
1
vote
0 answers

pd.ExcelWriter: export file defined in a variable to folder already created

I create the output folder inside the directory where the script is located dirName = './output' os.makedirs(dirName, exist_ok=True) I defined the name of the xlsx file that included the date: from datetime import datetime now =…
George
  • 11
  • 1
1
vote
1 answer

How to set border for merged cells in Pear Excel

How to set the border for merged cells in the PHP Pear Spreadsheet Excel writer?
Navin
  • 25
  • 1
  • 9
1
2 3