Need help to get started using xlrd, xlwt, and xlutlls
298 views
Skip to first unread message
Marcus Calligaro
Sep 15, 2016, 4:54:11 AM9/15/16
to python-excel
I am new Python developer and now i need to use excel and PDF's.
Please understand I do not want anyone to do the work for me. I just need help with these new tools I do not understand how to use.
For excel I plan to use xlrd to read the file, xlwt to write to the file, xlutlls for the Utllities to customnized my excel file, and pyoo to extract data from a PDF's.
I just reasonlly set up on my Windows 10 Python 2.7 and Anaconda 2 package manager where Python 2.7 is ran through Anaconda.
I have everything installed everything now like to see a video tutorial so I see how to get this working in my Python files.
How to import the package and commands to create a file to the finished spreadsheet.
Is there a user guide that shows me everything I need to know about all the packages that I have spoked of here. even a cheetsheet would help.
Since Anaconda is a Management system there maybe a different way of doing certain things.
Do I import using following code :
from sys import argv
script, user_name = argv
prompt = '> '
or do I need to add the path when I import?
C:\Users\IA Office\Anaconda2\pkgs
Please let me know how to get started. Because I have wrot the code with all the math already done in python. I just need to covert it to work with these packages.
Thanks,
Marcus
Please understand I do not want anyone to do the work for me. I just need help with these new tools I do not understand how to use.
For excel I plan to use xlrd to read the file, xlwt to write to the file, xlutlls for the Utllities to customnized my excel file, and pyoo to extract data from a PDF's.
I just reasonlly set up on my Windows 10 Python 2.7 and Anaconda 2 package manager where Python 2.7 is ran through Anaconda.
I have everything installed everything now like to see a video tutorial so I see how to get this working in my Python files.
How to import the package and commands to create a file to the finished spreadsheet.
Is there a user guide that shows me everything I need to know about all the packages that I have spoked of here. even a cheetsheet would help.
Since Anaconda is a Management system there maybe a different way of doing certain things.
Do I import using following code :
from sys import argv
script, user_name = argv
prompt = '> '
or do I need to add the path when I import?
C:\Users\IA Office\Anaconda2\pkgs
Please let me know how to get started. Because I have wrot the code with all the math already done in python. I just need to covert it to work with these packages.
Thanks,
Marcus
Charlie Clark
Sep 15, 2016, 4:59:55 AM9/15/16
to python...@googlegroups.com
Am .09.2016, 05:43 Uhr, schrieb Marcus Calligaro
<marcus.c...@gmail.com>:
>
> Is there a user guide that shows me everything I need to know about all
> the
> packages that I have spoked of here.
Please refer to http://www.python-excel.org/ for documentation of the
packages you mentioned.
I've deleted your duplicate postings but will keep you on moderation until
you learn how to use mailing lists correctly.
Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226
<marcus.c...@gmail.com>:
>
> Is there a user guide that shows me everything I need to know about all
> the
> packages that I have spoked of here.
packages you mentioned.
I've deleted your duplicate postings but will keep you on moderation until
you learn how to use mailing lists correctly.
Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226
Adrian Klaver
Sep 15, 2016, 9:22:35 AM9/15/16
to python...@googlegroups.com
On 09/14/2016 08:43 PM, Marcus Calligaro wrote:
> I am new Python developer and now i need to use excel and PDF's.
>
> Please understand I do not want anyone to do the work for me. I just
> need help with these new tools I do not understand how to use.
> For excel I plan to use xlrd to read the file, xlwt to write to the
> file, xlutlls for the Utllities to customnized my excel file, and pyoo
> to extract data from a PDF's.
> I just reasonlly set up on my Windows 10 Python 2.7 and Anaconda 2
> package manager where Python 2.7 is ran through Anaconda.
>
> I have everything installed everything now like to see a video tutorial
> so I see how to get this working in my Python files.
> How to import the package and commands to create a file to the finished
> spreadsheet.
See here:
> I am new Python developer and now i need to use excel and PDF's.
>
> Please understand I do not want anyone to do the work for me. I just
> need help with these new tools I do not understand how to use.
> For excel I plan to use xlrd to read the file, xlwt to write to the
> file, xlutlls for the Utllities to customnized my excel file, and pyoo
> to extract data from a PDF's.
> I just reasonlly set up on my Windows 10 Python 2.7 and Anaconda 2
> package manager where Python 2.7 is ran through Anaconda.
>
> I have everything installed everything now like to see a video tutorial
> so I see how to get this working in my Python files.
> How to import the package and commands to create a file to the finished
> spreadsheet.
https://github.com/python-excel/tutorial
Download the tutorial PDF, it covers xlrd, xlwt and xlrd.
>
> Is there a user guide that shows me everything I need to know about all
> the packages that I have spoked of here. even a cheetsheet would help.
> Since Anaconda is a Management system there maybe a different way of
> doing certain things.
>
> Do I import using following code :
>
> from sys import argv
>
> script, user_name = argv
> prompt = '> '
>
> or do I need to add the path when I import?
>
> C:\Users\IA Office\Anaconda2\pkgs
https://docs.python.org/2/tutorial/index.html
in particular:
https://docs.python.org/2/tutorial/modules.html
>
> Please let me know how to get started. Because I have wrot the code
> with all the math already done in python. I just need to covert it to
> work with these packages.
> Thanks,
> Marcus
>
--
Adrian Klaver
adrian...@aklaver.com
Marcus Calligaro
Sep 16, 2016, 1:50:31 PM9/16/16
to python-excel
Charlie,
I downloaded the tutorial and extracted it and wanted to know they are just files with nothing to install?
When I open the PDF and read through it there are couple upfront questions I have.
1) All packages are installed on the Anaconda Package Manager on my local system. Do I jump over the install process for these 3 packages?
2) Should I install Buildout?
3) You show Bootstrap file. Does this mean that in this tutorial nice looking when it is online?
4 Can i have a spreadsheet online i.e. app or website within these packages and save the file to a local machine?
Charlie you do not know how long I have been looking for these type of packages and tutorials that go with them its amazing.
Thanks,
Marcus
I downloaded the tutorial and extracted it and wanted to know they are just files with nothing to install?
When I open the PDF and read through it there are couple upfront questions I have.
1) All packages are installed on the Anaconda Package Manager on my local system. Do I jump over the install process for these 3 packages?
2) Should I install Buildout?
3) You show Bootstrap file. Does this mean that in this tutorial nice looking when it is online?
4 Can i have a spreadsheet online i.e. app or website within these packages and save the file to a local machine?
Charlie you do not know how long I have been looking for these type of packages and tutorials that go with them its amazing.
Thanks,
Marcus
Marcus Calligaro
Sep 16, 2016, 1:50:46 PM9/16/16
to python-excel
Adrian,
Thank you for the tutorials they look very helpful and will help me out a whole lot.
Marcus
Thank you for the tutorials they look very helpful and will help me out a whole lot.
Marcus
Charlie Clark
Sep 16, 2016, 1:53:16 PM9/16/16
to python...@googlegroups.com
Am .09.2016, 03:05 Uhr, schrieb Marcus Calligaro
<marcus.c...@gmail.com>:
> Charlie,
>
> I downloaded the tutorial and extracted it and wanted to know they are
> just
> files with nothing to install?
Just read them,
> When I open the PDF and read through it there are couple upfront
> questions
> I have.
>
> 1) All packages are installed on the Anaconda Package Manager on my local
> system. Do I jump over the install process for these 3 packages?
Obviously, if you already have them.
> 2) Should I install Buildout?
No.
> 3) You show Bootstrap file. Does this mean that in this tutorial nice
> looking when it is online?
No.
> 4 Can i have a spreadsheet online i.e. app or website within these
> packages
> and save the file to a local machine?
I don't really know what you mean but I don't think it is relevant. You
should just concentrate on working with your Excel files.
<marcus.c...@gmail.com>:
> Charlie,
>
> I downloaded the tutorial and extracted it and wanted to know they are
> just
> files with nothing to install?
> When I open the PDF and read through it there are couple upfront
> questions
> I have.
>
> 1) All packages are installed on the Anaconda Package Manager on my local
> system. Do I jump over the install process for these 3 packages?
> 2) Should I install Buildout?
> 3) You show Bootstrap file. Does this mean that in this tutorial nice
> looking when it is online?
> 4 Can i have a spreadsheet online i.e. app or website within these
> packages
> and save the file to a local machine?
should just concentrate on working with your Excel files.
robert99
Sep 17, 2016, 4:39:07 AM9/17/16
to python-excel
Marcus,
A very good book with 3 relevant chapters and examples to help you is Automate the Boring Stuff with Python.
A free chapter on Excel with Python using the alternative openpyxl module (supplied with Anaconda) instead is at:
https://automatetheboringstuff.com/chapter12/
Robert
A very good book with 3 relevant chapters and examples to help you is Automate the Boring Stuff with Python.
A free chapter on Excel with Python using the alternative openpyxl module (supplied with Anaconda) instead is at:
https://automatetheboringstuff.com/chapter12/
Robert
derek
Sep 17, 2016, 2:30:40 PM9/17/16
to python-excel
Re: "Can i have a spreadsheet online i.e. app or website within these packages and save the file to a local machine?"
Not clear by what you mean "have it on-line"? But if you wanted a tool that handles processing Excel-type files in the context of a web framework, then look at a tool like:
But as said already; first get comfortable working with the tools on your desktop before you add the complexity of a web app into the picture.
Charlie Clark
Sep 22, 2016, 5:42:08 AM9/22/16
to python...@googlegroups.com
Am .09.2016, 02:19 Uhr, schrieb robert99 <fordr...@gmail.com>:
> A very good book with 3 relevant chapters and examples to help you is
> Automate the Boring Stuff with Python.
> A free chapter on Excel with Python using the alternative openpyxl module
> (supplied with Anaconda) instead is at:
> https://automatetheboringstuff.com/chapter12/
It is a good book but unfortunately somewhat out of date when it comes to
> A very good book with 3 relevant chapters and examples to help you is
> Automate the Boring Stuff with Python.
> A free chapter on Excel with Python using the alternative openpyxl module
> (supplied with Anaconda) instead is at:
> https://automatetheboringstuff.com/chapter12/
openpyxl: we had to make some significant changes to the API while it was
being written.
Reply all
Reply to author
Forward
0 new messages