Note, if you have a new question, it is better to simply create a new topic
rather than adding to a thread that is several years old.
On Wednesday, July 26, 2017 at 5:30:11 AM UTC-4, kesh wrote:
>
> how can i import excel row into a web2py sqlite table
>
> On Wednesday, 2 February 2011 16:30:26 U
On Wednesday, July 26, 2017 at 2:30:11 AM UTC-7, kesh wrote:
>
> how can i import excel row into a web2py sqlite table
>
>
If the excel data is in CSV format, you can import that directly.
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Exporting-and-importing-data>
how can i import excel row into a web2py sqlite table
On Wednesday, 2 February 2011 16:30:26 UTC+3, Neveen Adel wrote:
>
> Hello,
>
> Is there a library that can be used to import an excel file that
> insert records in a specific table ?
>
> If there is no a library how can i do that ?
>
> T
Microsoft Excel .xls format (as well as the others) saves its files
out in custom binary formats. It is very difficult to import them
unless you have a way of decoding the binary format.
Using csv, you can easily set up auto-importers (as long as the csv
data-structure is fairly static).
This is a
Dear Brian,
Thanks a lot for your help.
On Feb 3, 4:29 am, Brian M wrote:
> Neveen,
>
> I've got a mini app that I upload excel files to for later parsing, here's
> now I do it. Getting the file would probably be even easier if you used an
> upload field in the DB & CRUD forms.
>
> def excel_u
Neveen,
I've got a mini app that I upload excel files to for later parsing, here's
now I do it. Getting the file would probably be even easier if you used an
upload field in the DB & CRUD forms.
def excel_uploader():
response.subtitle = "Upload excel file "
from gluon.sqlhtml import for
Thanks a lot Bruno Rocha for ur reply :)
But these packages are used after uploading the file.
I want to know the step before that, what i want to do simply is to
have a browse button to choose CSV file and then press upload then i
can by using one of the packages u suggested to read the CSV file
sticking purely to text, is there a difference between an excel file
and csv? if formatted properly, it should be the same thing. Extension
names are only incidental, if web2py has the extension hard coded in
its look up, then you should be able to simply rename the file...
On Feb 2, 9:58 am, Brun
Take a look at this pack:http://www.python-excel.org/
Bruno Rocha
http://about.me/rochacbruno/bio
Hello Kenneth,
Thanks for your reply:)
It is ok about import/export CSV files, How can i do this into my
application ?
On Feb 2, 3:39 pm, Kenneth Lundström
wrote:
> I know you can import/export CSV-files and export XLS files. But I don t
> know if there is a way to import XLS files directly.
>
10 matches
Mail list logo
