Tag: python

Comparing the content of a cell with a string using find

This might sounds like a very basic question but i’m only learning python since monday morning for my master thesis (yes, to answer every question about that, I’m really in a hurry due to unexpected circumstances), and I encountered a big problem which I cannot solve : I would like to upload an excel file […]

How to get rid of the footer when create an html from an excel file with python

Hi: Im creating an HTML from an excel file who has just 1 sheet. Im dont want to use any vb macro, just python code. I can create my HTML but when I open it, I have the excel footer in the HTML showing me the sheet name. I want to get rid of that. […]

read only error while reading data from excel in python

I am new to python. I have written a sample code to read data from excel in python. from openpyxl import load_workbook import logging logging.basicConfig(level=logging.DEBUG) wb = load_workbook(filename = ‘names.xlsx’, use_iterators = True) for sheet in wb.get_sheet_names(): worksheet = wb.get_sheet_by_name(name=sheet) print sheet if worksheet: index = 2 append_brace = False while True: gender_index = ‘B’ […]

How to compile Python 3.4 and Excel files into .exe

I’ve written a Python script that drives several macros in various Excel files to format some tab-delimited data files a very specific way to be used by another program. I didn’t write the Excel macros and I’d prefer not to rewrite the macros into straight Python code at this point. My customers are happy with […]

python script to export csv file – not imported correctly on tablepress

I tried to solve this problem, but it’s just not working. The code exports a .csv file that can be viewed fine in excel (but it skips a line every line..), but when i upload to tablepress or websimontables the code puts all of the rows in one cell instead of each in their own […]

CSV in Excel Table in Python

I’m trying to input CSV information into a table in Excel but I don’t know how, it would also help if I could create the table in a python script as well as reading in the CSV file in the same script. Please help.

Python: How to open a multisheet .xslx file (with formatting) and edit a few cells and save it as another .xlsx file

I have tried using openpyxl but it seems to fail when I am saving the file (http://pastebin.com/VU5LTajH) and I cannot find any info about the problem. Any other modules that let you read edit and save an .xlsx file while retaining the style and formatting of the original file?

excel cannot recognize newline character in a csv file

This question already has an answer here: Generating CSV file for Excel, how to have a newline inside a value 16 answers

Using python to remove file metadata?

I’m periodically asked to remove the metadata of a file before it goes to the client. I was recently asked to do it for a very large number of pdf and excel files — so many that writing a script seemed like a natural solution. A quick google led me to shutil.copyfile(src, dst): Copy the […]

How to load different language into dataframe?

When I try to load my excel file with: pd.read_excel(filename) It does not make a a Dataframe unless I delete the column with the french (i.e Vérité, café). I tried switching the encoding=’utf-8′ but it didn’t work. Please help.

MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.