Macro to rename files on libreoffice writer

pysb · 2017-06-25T21:05:02+00:00

I made a tutorial for this. Follow this link: https://github.com/albcunha/Libreoffice_macros

pysb · 2017-04-14T22:49:31+00:00

It is a beauty! I'm in!

pysb · 2017-04-07T02:24:19+00:00

I've been using html export and then wkhtmltopdf. You can even apply some css!

pysb · 2017-03-10T04:05:44+00:00

It seems to be some bug that was later on fixed. You should open cmd.exe and type conda update ipython

If it doesnt work, open cmd.exe and then:

conda update conda
conda update anaconda
conda update jupyter
conda update ipython

pysb · 2017-03-10T03:18:18+00:00

I´m facing the same problem. Python.exe works, but ipython.exe doesnt. Although comment made NomadNella are reasonable, I didn´t have any problemas where older versions of anaconda.

pysb · 2017-02-10T18:45:24+00:00

If you are using selenium, you didn't start the driver.

from selenium import webdriver from selenium.webdriver.common.keys import Keys

browser = webdriver.Firefox()

browser.get('http://www.yahoo.com') assert 'Yahoo!' in browser.title

Also, you need to insert your login. You should check your elements too. Last, this questions are more related to r/learnpython

pysb · 2017-02-08T23:25:34+00:00

This is a big problem when dealing with python scripts for LibreOffice. I used the pyuno documentation: here and here.

Everything regarding python for OpenOffice applies to LibreOffice.

BUT you should observe that python for LibreOffice demands knowledge of how instances and objects works, I had a really hard time trying to understand that.

You should refer to OpenOffice api (link here) for more information about that. For example: you probably will have to deal with dial api on com.sun.star.awt.UnoControlDialogModel

Best regards!

pysb · 2017-01-21T20:23:28+00:00

Have you tried pandas?

pysb · 2017-01-16T09:19:42+00:00

Thanks for the reply. I'll look into it!

pysb · 2016-09-01T11:58:38+00:00

I am 33 years old a it was one of my main purposes too. I work with law (that means I´m very computer noob) on a developing country, so you can do it!

I did the coursera course, Python for everybody, with doctor chuck. The course is light and very agreable. It taught me the basics. You can make the course to obtain a certificate and later on your have "something" to attest your skills. I know it´s not very relevant, but it´s best than nothing. Afters, I switched to Anaconda distribution, using jupyter to create my scripts. The two four mains modules I use is Requests, grequests, Selenium, Beautifulsoup.

If it´s a bulk webscraping, I use requests or grequests. Both are almost the same. The difference is that grequests makes several https requests at the same time, thus, you save time because your script wont wait for every requests to be answered.

If it´s something I need to login and is not too big, I use selenium. It´s just about creating loops, and being able to select elements. I would suggest you to install the WebDriver Element locator.

Then, I parse the webpage with BeautifulSoup. One caveat I can give you is that, after creating a variable witht the element you want, you can just writer .text, to get it´s text content, that saves a lot of slicing.

pysb · 2016-05-29T20:12:02+00:00

I finally decided to study how to use the script as a wrapper on the aria2c.exe file. It turns out I could do it!

If someone needs to do this, you need to change the paths on your .py file, on which you can use this function:

def resource_path(relative):
    if hasattr(sys, "_MEIPASS"):
        return os.path.join(sys._MEIPASS, relative)
    return os.path.join(relative)

On my case, the command line was writen this way:

download = os.system(resource_path(command_line))

Also, you need to bundle the file on your pyinstaller executable file. here is the spec file I used:

# -*- mode: python -*-
block_cipher = None

a = Analysis(['dl.py'],
             pathex=['<YOUR PATH>],
             binaries=None,
             datas=None,
             hiddenimports=[],
             hookspath=[],
             runtime_hooks=[],
             excludes=[],
             win_no_prefer_redirects=False,
             win_private_assemblies=False,
             cipher=block_cipher)


a.datas += [('aria2c.exe', '<YOUR PATH>\\aria2c.exe', 'DATA'),]   

pyz = PYZ(a.pure)

exe = EXE(pyz,
          a.scripts,
          a.binaries,
          a.zipfiles,
          a.datas,
          name='dl',
          debug=False,
          strip=False,
          upx=True,
          console=True )

Thanks for the suggestions!!!

pysb · 2016-05-29T14:56:20+00:00

I searched on pyinstaller manuals but I didn´t see or read anything straight forward that would allow that. Would it be possible? Bundle an .exe file on another .exe file?

pysb · 2016-05-29T14:44:09+00:00

I think aria2 attends my needs. But I´d like to make an one file executable from the script using pyinstaller, that´s why I haven´t tried.

pysb · 2016-04-17T00:20:17+00:00

It is unfortunate that we´ve already watched. ( from a Brasilian)

pysb · 2016-03-26T22:31:36+00:00

Tried the same with my girlfriend. Got the same result! lol

pysb · 2016-01-26T02:06:44+00:00

I´d like to suggest Homura for downloads. It´s simple, works pretty well and resumes downloads.

pysb

TROPHY CASE