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 […]
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. […]
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’ […]
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 […]
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 […]
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.
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?
This question already has an answer here: Generating CSV file for Excel, how to have a newline inside a value 16 answers
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 […]
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.