jasonrogena / jasonrogena/php-excel-reader

microsoft excel 2003 format from macro export of access not importing correctly has symbols in database

Open
#126 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
Dominant language
PHP
Stars
1
Forks
0
PR merge metrics
No merged PRs in 30d

Description

```
What steps will reproduce the problem?
1.export from microsoft access through a Macro to excel
2.creates a excel file format excel 2003
3.use php-excel-reader

What is the expected output? What do you see instead?
normal excel files import fine without issues. But when I use the export from
access macro.. I get symbols in the database and only parts of each cell in the
file. When I open the .xls file excel it open without any issues. Is the
macro created file not supported even though its exported in the excel 2003
format?

```

Original issue reported on code.google.com by `david.dr...@tenethealth.com` on 11 Aug 2011 at 5:37

Contributor guide

No contributing guide indexed for this repository

Research direction

No source file, test, or sample fixture is named. Start by reproducing the import with an Access macro-generated Excel 2003 file and a normal .xls file, then inspect the parser entry point to find where symbols and truncated cell values arise. Done means the generated file imports with complete, correct cell contents.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.