unreadable content not yet resolved

[Vicky]

As mentioned in below link
http://cpansearch.perl.org/src/JMCNAMARA/Excel-Writer-XLSX-0.37/Changes

Below issue is not yet fixed .

0.19 May 5 2011

! Fixed issue with chart scaling that caused "unreadable
content"
Excel error.

When i tried writing xlsx file (approximate 13612 lines) using given
module , i got this error
"Excel found unreadable Content in "filename.xlsx".Do you want to
recover the contents of this workbook ? If you trust the source if
this workbook ,Click Yes."

When i tried for same functionality for 6400 Lines , the module works
fine without any issue .

Let me know if you have any solution to resolve given issue.

[jmcnamara]

On Jul 9, 1:25 pm, Vicky <vikram.ainch...@gmail.com> wrote:
> When i tried writing xlsx file (approximate 13612 lines) using given
> module ,  i got this error
> "Excel found unreadable Content in "filename.xlsx".Do you want to
> recover the contents of this workbook ? If you trust the source if
> this workbook ,Click Yes."
>
> When i tried for same functionality for 6400 Lines , the module works
> fine without any issue .
>
> Let me know if you have any solution to resolve given issue.

Hi,

The "Excel found unreadable content warning" is a general warning and
may be caused by a number of different issues.

The one referred to in the Changelog was specifically related to chart
scaling. If you don't have scaled charts in your application then you
aren't encountering that issue.

In order to debug the issue that you are having:
1. Ensure you are using the latest version of Excel::Writer::XLSX
(currently 0.48).
2. Try to create a small, self-contained program that demonstrates
the issue.
3. If you can't do 2, then send me one of the xlsx files that
gives the error to the address in the documentation.

Regards.

John.
--

[vikram ainchwar]

Thanks for Reply ...

I got below error after recovering the file ... any idea what can be the issue , i will try to get some error file if possible .

 

  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 

- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

  <logFileName>error028160_01.xml</logFileName> 

  <summary>Errors were detected in file 'D:\Users\****\Desktop\cdr_7449937.xlsx'</summary> 

- <repairedRecords summary="Following is a list of repairs:">

  <repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet1.xml part</repairedRecord> 

  </repairedRecords>

  </recoveryLog>

--
You received this message because you are subscribed to the Spreadsheet::WriteExcel Google Group.

For posting and other options visit this group at:
http://groups.google.com/group/spreadsheet-writeexcel?hl=en

You can also post by sending an email to:
http://groups.google.com/group/spreadsheet-writeexcel?hl=en

To unsubscribe send an email to spreadsheet-write...@googlegroups.com

--
Regards

VIKRAM A AINCHWAR
 
09860149244

[vikram ainchwar]

Hi John,

Can you check below Blog , for this issue ... 

http://dracoater.blogspot.in/2009/05/export-string-values-to-excel-2007.html

[John McNamara]

On 9 July 2012 14:57, vikram ainchwar <vikram....@gmail.com> wrote:

Thanks for Reply ...

I got below error after recovering the file ... any idea what can be the issue , i will try to get some error file if possible .

 

Hi Vikram,

 

Unfortunately that log doesn't contain enough information about the issue. I will need a test program or the full file to analyse the issue.

 

John.

--

 

[John McNamara]

On 9 July 2012 15:16, vikram ainchwar <vikram....@gmail.com> wrote:

Can you check below Blog , for this issue ... 

http://dracoater.blogspot.in/2009/05/export-string-values-to-excel-2007.html

 

 

Hi Vikram,

 

That may be the same issue or it may not be. There is no way to tell without a test program or example file.

 

John.

--