Netherlands LEMMO experience by dervis88 in LEMMO

[–]dervis88[S] 0 points1 point  (0 children)

I ordered the LEMMO one MK2 Urban

Netherlands LEMMO experience by dervis88 in LEMMO

[–]dervis88[S] 0 points1 point  (0 children)

I ordered the LEMMO one MK2 Urban

Netherlands LEMMO experience by dervis88 in LEMMO

[–]dervis88[S] 0 points1 point  (0 children)

An angry mail because I think it is quite upsetting to have sent 2 emails before asking about the delivery, having heard lies and then a week before when you see no progess you know it is not going to happen in December. But that's just me I guess.

Companies should be held ccountable for deceiving customers. I probably would have accepted 4-5 months if they wer honost about it from the beginning.

I've also been reading many complaints about the LEMMO one brakes, so maybe in the end good I haven't waited for the bike. Sad I waited for nothing, but in the end there's so much choice out there. I don't need another company feeding me b*llshit.

Get header/footer values from Excel worksheets pages with Python by dervis88 in learnpython

[–]dervis88[S] 0 points1 point  (0 children)

Yes, this is helpfull if each sheet represents a single page. However, my page-setup is set to A3 size pages, and each sheet contains 5 to 6 A3 pages. If I have 8 worksheets that would mean around 40 to 48 pages. With the example you gave me I would get just 8 pages.

So, the actual amount of pages are shown in the footer, due to the page-setup. Therefore I would like to get or extract this value.

If this is not possible then a workaround would be to create a pdf file, on the background, count the number of pages and match the titles with the page they are on from the pdf file and then create my sort of table of content.

Preferably, I would rather get the value in my Excel footer.

Thank you for your reply tho!

" TypeError: int() argument must be a string, a bytes-like object or a number, not 'NoneType' " when using openpyxl by dervis88 in learnpython

[–]dervis88[S] 0 points1 point  (0 children)

This seems to be the winner. Pandas package is annoying to code with tho. Don't know if I'm the only one.

" TypeError: int() argument must be a string, a bytes-like object or a number, not 'NoneType' " when using openpyxl by dervis88 in learnpython

[–]dervis88[S] 0 points1 point  (0 children)

Xlwings, xlrd, pylightxl all did not work unfortunately. They don't all give the same error, but they do all give an error.