You are here

Home » API reference » Feeds Excel 6

README.txt in Feeds Excel 6

Same filename and directory in other branches
  1. 7.2 README.txt
  2. 7 README.txt
This module provides an Excel parser for feeds.module.

Requirements
============
- Feeds 1.x
  http://drupal.org/project/feeds
- Token 1.x
  http://drupal.org/project/token
- Libraries API 1.x
  http://drupal.org/project/libraries
- phpExcelReader
  https://github.com/derhasi/phpExcelReader/zipball/interim2
  (originally on http://sourceforge.net/projects/phpexcelreader/files/Spreadsheet_Excel_Reader/Interim%20update/phpExcelReader.zip/download
  but for really being able to use it, it has to be modified, so lives on github for that)

Installation
============
- Install Feeds, Feeds Admin UI and its dependecnies
- Copy this module to your modules directory
- Place the phpExcelReader in the libraries-folder (see below)
- Enable feeds_excel

Now it can be used as parser in Feeds imports.

Problems with large files
=========================
There's a bottle neck in batch processing of feeds.module at the moment. This
can cause (large) excel files not getting completely imported. For more
information on this issue visit http://drupal.org/node/712304.

Parser Settings
===============
Mapping mode:
  Currently there are two modes:
  * "rows" runs through iterative range row-by-row, so each row is a new dataset
  * "columns" runs through iterative range column-by-column, so each column is a new dataset

Fixed Range:
  a region that holds absolute variables, that can be fetch by [sheet-cell-R-C],
  where R represents the row number and C the column number

Iterative Range:
  This is the region where datasets are processed from, either by row or by
  column.

Header Range:
  This option is currently disabled.

Keys for mapping sources
========================
Keys are processed through token.module, so you can inspect possible keys in the
"Legend sources" fieldset on the mapping settings page.

phpExcelReader
==============
The module needs phpExcelReader placed into libraries, so reader.php is located
at sites/all/libraries/phpExcelReader/Excel/reader.php

The library was originally placed at http://sourceforge.net/projects/phpexcelreader/
but needed some modification to work. So I forked it to github:
https://github.com/derhasi/phpExcelReader

There you can download the archive at https://github.com/derhasi/phpExcelReader/zipball/interim2

File

README.txt
View source 
  1. 

  2. This module provides an Excel parser for feeds.module.

  3. 

  4. Requirements

  5. ============

  6. - Feeds 1.x

  7.   http://drupal.org/project/feeds

  8. - Token 1.x

  9.   http://drupal.org/project/token

  10. - Libraries API 1.x

  11.   http://drupal.org/project/libraries

  12. - phpExcelReader

  13.   https://github.com/derhasi/phpExcelReader/zipball/interim2

  14.   (originally on http://sourceforge.net/projects/phpexcelreader/files/Spreadsheet_Excel_Reader/Interim%20update/phpExcelReader.zip/download

  15.   but for really being able to use it, it has to be modified, so lives on github for that)

  16. 

  17. Installation

  18. ============

  19. - Install Feeds, Feeds Admin UI and its dependecnies

  20. - Copy this module to your modules directory

  21. - Place the phpExcelReader in the libraries-folder (see below)

  22. - Enable feeds_excel

  23. 

  24. Now it can be used as parser in Feeds imports.

  25. 

  26. Problems with large files

  27. =========================

  28. There's a bottle neck in batch processing of feeds.module at the moment. This

  29. can cause (large) excel files not getting completely imported. For more

  30. information on this issue visit http://drupal.org/node/712304.

  31. 

  32. Parser Settings

  33. ===============

  34. Mapping mode:

  35.   Currently there are two modes:

  36.   * "rows" runs through iterative range row-by-row, so each row is a new dataset

  37.   * "columns" runs through iterative range column-by-column, so each column is a new dataset

  38. 

  39. Fixed Range:

  40.   a region that holds absolute variables, that can be fetch by [sheet-cell-R-C],

  41.   where R represents the row number and C the column number

  42. 

  43. Iterative Range:

  44.   This is the region where datasets are processed from, either by row or by

  45.   column.

  46. 

  47. Header Range:

  48.   This option is currently disabled.

  49. 

  50. Keys for mapping sources

  51. ========================

  52. Keys are processed through token.module, so you can inspect possible keys in the

  53. "Legend sources" fieldset on the mapping settings page.

  54. 

  55. phpExcelReader

  56. ==============

  57. The module needs phpExcelReader placed into libraries, so reader.php is located

  58. at sites/all/libraries/phpExcelReader/Excel/reader.php

  59. 

  60. The library was originally placed at http://sourceforge.net/projects/phpexcelreader/

  61. but needed some modification to work. So I forked it to github:

  62. https://github.com/derhasi/phpExcelReader

  63. 

  64. There you can download the archive at https://github.com/derhasi/phpExcelReader/zipball/interim2