You are here

Home » API reference » Feeds Excel 7

README.txt in Feeds Excel 7

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

Requirements
============
- Feeds 1.x
  http://drupal.org/project/feeds
- Libraries 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)

The token module is recommended, so token replacement patterns can be viewed for
help on the feeds mapping settings page.


Installation
============
- Install Feeds, Feeds Admin UI and its dependecnies
- Copy this module to your modules directory
- Place the phpExcelReader in sites/all/libraries, so reader.php is located at
  sites/all/libraries/phpExcelReader/Excel/reader.php
- Enable feeds_excel

Now it can be used as Parser in Feeds.

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 see 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/modules/custom/feeds_excel/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. - Libraries 1.x

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

  10. - phpExcelReader

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

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

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

  14. 

  15. The token module is recommended, so token replacement patterns can be viewed for

  16. help on the feeds mapping settings page.

  17. 

  18. 

  19. Installation

  20. ============

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

  22. - Copy this module to your modules directory

  23. - Place the phpExcelReader in sites/all/libraries, so reader.php is located at

  24.   sites/all/libraries/phpExcelReader/Excel/reader.php

  25. - Enable feeds_excel

  26. 

  27. Now it can be used as Parser in Feeds.

  28. 

  29. Problems with large files

  30. =========================

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

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

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

  34. 

  35. Parser Settings

  36. ========

  37. Mapping mode:

  38.   Currently there are two modes:

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

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

  41. 

  42. Fixed Range:

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

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

  45. 

  46. Iterative Range:

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

  48.   column.

  49. 

  50. Header Range:

  51.   This option is currently disabled.

  52. 

  53. Keys for mapping sources

  54. ========================

  55. Keys are processed through token.module, so see the "Legend sources" fieldset

  56. on the mapping settings page.

  57. 

  58. phpExcelReader

  59. ==============

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

  61. at sites/all/modules/custom/feeds_excel/libraries/phpExcelReader/Excel/reader.php

  62. 

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

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

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

  66. 

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