Thread: Xls2csv

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0

    Xls2csv


    Hello everyone!
    I tried to install the xls2csv from the pack "catdoc" on my shared hosting. but I cant do that.. that I did for it:
    1) I installed the module Locale::Recode (path $HOME/perl). the xls2csv need it
    2) I created a file .profile with strings:
    Code:
    PERL5LIB=$HOME:$HOME/lib:$HOME/lib/perl5
    export PERL5LIB
    3) downloaded pack "catdoc" and did commands:
    Code:
    ./configure -prefix=$HOME/perl
    make
    make install
    no errors after

    and that happen if I try to use xls2csv
    Code:
    xls2csv -x test.xls -c test.csv
    Cannot load charset koi8-r - file not found
    Cannot load target charset koi8-r
    but i can see these files - $HOME/perl/share/catdoc/koi8-r.txt

    if i change encoding on uft-8:
    Code:
    xls2csv -d utf-8 -x test.xls -c test.csv
    then:
    Code:
    Cannot read substitution map ascii.specchars
    Can anybody help me? Thanks for some help!
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    2
    Rep Power
    0

    Talking


    sorry , was busy. cencerning a my mistake
    basically everything is correct, problem is the module and the instruction was from a different module with the same name

    so, we have to start from point 3 - everything should work

    there is an instruction on creation of the config. file:
    URL=http://linux.die.net/man/1/catdoc of course, if we will want to change something

    we may use it:
    Code:
    xls2csv -s cp1252 -d cp1252 -x "Path_of_xls" > "Path_of_csv"
    -s - source
    -d - destination

IMN logo majestic logo threadwatch logo seochat tools logo