Stack Overflow
Stack Overflow

Questions tagged [parseexcel]

16 questions
14
votes
3 answers

How do I read the content of an Excel spreadsheet using Ruby?

I am trying to read an Excel spreadsheet file with Ruby, but it is not reading the content of the file. This is my script book = Spreadsheet.open 'myexcel.xls'; sheet1 = book.worksheet 0 sheet1.each do |row| puts row.inspect ; puts row.format…
Pavunkumar
  • 5,147
  • 14
  • 43
  • 69
2
votes
0 answers

Is there a way to read comments/notes of a cell in an excel file with ParseExcel/ParseXLSX?

use Spreadsheet::ParseExcel; ... ... my $cell = $worksheet->get_cell($row,$column); $cell_value = $name->value(); This gets the value stored in the cell. If I have comments/notes associated with this cell, how can I fetch it? Thanks!
kvi
  • 21
  • 1
2
votes
1 answer

Need help installing Spreadsheet::ParseExcel

I am trying to install Spreadsheet::ParseExcel to use with ExcelLatex. This is what I did: Installed Active perl, Then install CPAN.pm by perl -MCPAN -e shell I was asked for configuration and mirror site and I let perl do the auoconfoguration. At…
NNsr
  • 1,023
  • 2
  • 11
  • 25
1
vote
0 answers

Read and convert monthly grid excel file data in javascript

I tried to read monthly food menu from excel in javascript (actually .net core mvc project). But the excel template not usual, the excel data looks like a monthly, how can I parse and read this ?
hkyaaa
  • 100
  • 9
1
vote
1 answer

Format of the date field gets changed through Spreadsheet::ParseExcel

I have an Excel Sheet (A.xls) which has following content: Date,Value 10/1/2020,36.91 10/2/2020,36.060001 I got following output using same script with Perl v5.6.1 on solaris 5.8 >>./a4_test.pl INFO>Excel File=A.xls,#WorkSheet=1,AuthorID=Sahoo,…
Ashish Sahoo
  • 75
  • 7
1
vote
1 answer

Install problems with Spreadsheet::ParseExcel

I am trying to install Spreadsheet::ParseExcel from CPAN and experiencing some problems. I have installed other packages before without issue. I first tried cpanm Spreadsheet::ParseExcel, but it ultimately fails on the building and testing stage. I…
Jeff Erickson
  • 3,783
  • 8
  • 36
  • 43
1
vote
1 answer

Spreadsheet:: ParseExcel in PERL query

I am writing a PERL code to pick values from specific rows of a particular excel sheet. I am using the Spreadsheet::ParseExcel module for this purpose. I have written this code as of now use Spreadsheet::ParseExcel::FmtDefault; use…
The Last Word
  • 203
  • 1
  • 7
  • 24
1
vote
2 answers

how to read content of cell nt formula in perl

I do have the following code in perl that open an excel file and read row:column, what I want to get is the content of the cell not formula, the get_cell (0,1) and (1,1) and (2,1) has some formula, and value, I'm not interested in formula just the…
user2912312
  • 155
  • 1
  • 3
  • 13
1
vote
2 answers

Perl - Unable to access Excel File

I'm trying to explore Perl and do some sample code. I tried to read excel use Perl. I downloaded Spreadsheet-ParseExcel and installed in my machine. I tried below code: Code #!"C:\Perl64\bin\perl.exe" use CGI; use strict; use…
chinna_82
  • 6,353
  • 17
  • 79
  • 134
1
vote
2 answers

Spreadsheet::ParseExcel row_range differs from gnumeric

I'm having trouble getting Spreadsheet::ParseExcel to parse an .xls spreadsheet generated by gnumeric, and I think the problem is with gnumeric. ParseExcel's row_range() method is returning (0, 500) when only 285 rows are in use. I tried selecting…
Chap
  • 3,649
  • 2
  • 46
  • 84
1
vote
0 answers

Prevent losing graphs when using Spreadsheet::ParseExcel

I need to edit the data and graphs of an excel file. I can edit the data but graphs are lost. Spreadsheet::ParseExcel says: You can only rewrite the features that Spreadsheet::WriteExcel supports so macros, graphs and some other features in the…
user2190527
  • 11
  • 2
1
vote
3 answers

ParseExcel worksheet get_name()

Using certain old versions of ActivePerl, reading a spreadsheet: use Spreadsheet::ParseExcel; $excel = Spreadsheet::ParseExcel::Workbook->Parse("some file"); foreach $sheet (@{$excel->{Worksheet}}){ print $sheet->get_name(); } Error: Can't…
OJW
  • 4,514
  • 6
  • 40
  • 48
0
votes
0 answers

ParseExcel ignoring qoutes in cells

I have cells in my spreadsheet which are containing quoted strings but when I read via the method cell->value the qoutes are ignored/dropped. "String" gets read as String What is the correct way to have the quotes not ignored via this Perl module -…
Carl Wainwright
  • 328
  • 5
  • 18
0
votes
1 answer

Excel sheet parsing

I'm trying to parse one Excel spreadsheet which has a field named "Status" (possible values PASS/FAIL). I want the total no. of records for PASS status and that of FAIL status. Can anyone help me?
Anupriya
  • 23
  • 3
0
votes
1 answer

Spreadsheet::ParseExcel won't read the file

I have a Perl script that I wrote and ran in windows that reads the contents of a .xls file using Spreadsheet::ParseExcel. When I transfer the xls file and the perl script over to a linux server to run it, it can't read any of the data in the xls…
yankees13
  • 125
  • 5
1
2