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
1
vote
0 answers

format excel using php

Here i am trying to format excel using PHP-Spreadsheet/Excel/Writer.php, i see crashed data in excel once it gets downloaded.Below is the screen shot of the image.I have googled and tried couple of solutions. Still the same can any one please help…
3bu1
  • 977
  • 12
  • 30
1
vote
1 answer

NullPointerException in createRow method in HSSFSheet

I am trying to write data in excel. FileOutputStream oFile = new FileOutputStream(yourFile, false); HSSFWorkbook workbook=new HSSFWorkbook(); HSSFSheet sheet=workbook.createSheet("Script_ID"); HSSFRow rowheading =sheet.createRow(0); //…
monk_507
  • 27
  • 2
1
vote
1 answer

Pear - spreadsheet_excel_writer insertBitmap function error

I am stuck into the problem in SPREADSHEET_EXCEL_WRITER. When i am using insertBitmap() function it is generating an error and not embeding the bitmap image in excel. I have gone through the link (PEAR Spreadsheet_Excel_Writer insertBitmap() not…
tanrich
  • 21
  • 6
1
vote
1 answer

Can't include Spreadsheet Excel Writer

I have a problem with Pear package Spreadsheet Excel Writer. I want to generate excle file from php and found this package on internet. I copied smaple code from official page, but it doesn't work. Of course I have the pear installed on my…
manveruPL
  • 57
  • 2
  • 11
1
vote
1 answer

Spreadsheet_Excel_Writer in PHP: align a single cell

I am currently working with the Spreadsheet_Excel_Writer in PHP. It works fine with the data I have. But now I want to format my data. Let's say I have 3 columns: Position, Article and Price. The Spreadsheet_Excel_Writer writes each line…
Alex K.
  • 707
  • 1
  • 11
  • 25
1
vote
2 answers

Excel::Writer::XLSX Page View and Page Breaks (Perl)

I've searched the API, Google, StackOverflow, etc. trying to find an answer to the following questions, but thus far, my quest has been disappointing. Is anyone out there able to help me out? 1) I'm attempting to use the set_page_view() option to…
etspaceman
  • 520
  • 5
  • 9
0
votes
2 answers

import excel read row by row then insert into database c# with softartisans ExcelWriter

trying to import bulk data from excel sheet with softartisans ExcelWriter.i do not find much sample code to read row by row and insert into database can i get sample code to read and insert row by row in c# imported excel file saved in temp location…
kumarjcet
  • 419
  • 1
  • 5
  • 8
0
votes
0 answers

UTF-8 Encode error but it's already encoded

I've taken a PDF and converted it to text which i'm trying to break up into different sections by "FIGURE". When I run my code on a subset of the whole text file it runs, but when I try to do the whole text file it doesn't run. Any Ideas? this is…
user3473269
  • 15
  • 3
0
votes
2 answers

Unable to save an Excel file to a folder in php

I am using excelwriter.class.php library to create an Excel file and to write data into it. This is my code:
manikandan
  • 139
  • 1
  • 2
  • 15
0
votes
0 answers

How to use PHP excel Class to generate excel files in Zend Framwork?

I am new to zend framwork, previously worked on cakePHP. I have used ExcelWriter by creating a component. but I dont think Zend having such kind of facilities or not. Can anyone help me in this case? My Component Code to be used with Zend Link
AWE
  • 213
  • 1
  • 4
  • 12
0
votes
1 answer

get string to excel and consider the (TAB) spaces

I have a program where I get a string from a text area and then I convert it to an array, then I read this array and then write it to an excel, the writing is working but it doesn't consider the tab spaces. My code is String getTextArea_1 =…
Aboelmagd Saad
  • 69
  • 7
0
votes
3 answers

Spreadsheet_Excel_Writer get file content

I need to attach an XLS-file to e-mail via PHP. The Problem is - Spreadsheet_Excel_Writer send a HTTP Header to a browser an then the content. Spreadsheet_Excel_Writer API has no any functions like get_content to become the file content directly. I…
Vov4ik
  • 323
  • 1
  • 6
  • 14
0
votes
1 answer

$xml->writeData(); not working on ExcelWriterXML

I am running this on MAC, the xml file is creating but the data is not written into the file. Please, Kindly help. Thanks docTitle('My Demo Doc'); …
user3421210
  • 1
  • 1
0
votes
1 answer

Insert images to Excel file with ExcelWriter() PHP

I'm exporting a data in XLS format with the use of ExcelWriter() in PHP. In some cases I have a data in image format (stored as a path). is that possible to directly show images in the excel?
Parthi04
  • 1,121
  • 4
  • 21
  • 39
0
votes
1 answer

Development server using Spreadsheet_Excel_Writer not working?

I'm running the latest PHP and pear on a windows machine with apache 2.4 (XAMPP), I have installed the latest versions of OLE, PEAR and Spreadsheet_Excel_Writer. PEAR is installed and working. However now instead of generating a download for the…
tread
  • 10,133
  • 17
  • 95
  • 170
1
2
3