NFS Shift 2 Unleashed
Shift 2 Unleashed PC Patch 1.02
Shift 2 Unleashed 1.0.16
Shift 2 Unleashed 1.0.16.Q:
Is it possible to convert table from word/thumnail view into a spread sheet like view in office or open office?
I am wondering if its possible to turn a table (with 2 columns of data) from a word document into a tabular form that can be used in the spread sheet like in Microsoft office or Open Office, so that it can be read easier.
Is it possible to change the presentation of the data like this?
To this
I want to do this because I need to export the data to a CSV file. I have tried to do this by using xlsxwriter. But there seems to be an error as xlsxwriter cannot handle the table data like this.
This is the code I am using
import openpyxl
import pandas as pd
wb = openpyxl.load_workbook('table2.xlsx')
ws = wb.active
table = pd.read_csv('table2.csv', header=None)
table.to_excel('table2.xlsx', 'tablename')
wb.save('table2.xlsx')
the original code can be seen here
A:
This seems to work just fine for me:
import openpyxl
import pandas as pd
wb = openpyxl.load_workbook('table2.xlsx')
ws = wb.active
table = pd.read_excel('table2.xlsx', header=None)
table.to_excel('table2.xlsx', 'tablename')
wb.save('table2.xlsx')
Outputs
However, to answer your question about conversion, you don't need to use pandas, ExcelWriter, or xlsxwriter for this; just download the OpenPyxl ExcelWriter:
Then use it like this:
import openpyxl
with open('table2.xlsx', 'rb') as 01e38acffe
Oct 24, 2020
.
Oct 22, 2020
.
Oct 21, 2020
.
Oct 20, 2020
.
Oct 16, 2020
.
Oct 15, 2020
.
Oct 14, 2020
.
Oct 13, 2020
.
Oct 12, 2020
.
Oct 11, 2020
.
Oct 9, 2020
.
Oct 8, 2020
.
Oct 5, 2020
.
Oct 4, 2020
.
Oct 3, 2020
.
Oct 2, 2020
.
Sep 28, 2020
.
Sep 27, 2020
.
Sep 26, 2020
.
Sep 25, 2020
.
Sep 24, 2020
.
Sep 23, 2020
.
Sep 22, 2020
.
Sep 21, 2020
.
Sep 20, 2020
.
Sep 19, 2020
.
Sep 18, 2020
.
Sep 17, 2020
.
Sep 16, 2020
.
Sep 15, 2020
.
Sep 14, 2020
.
Sep 13, 2020
.
Sep 12, 2020
.
Sep 11, 2020
.
Sep 10, 2020
.
Sep 9, 2020
.
Sep 8, 2020
.
Sep 7, 2020
.
Sep 6, 2020
.
Sep 5, 2020
.
Sep 4, 2020
.
Sep 3, 2020
.
Sep 2, 2020
.
Sep 1, 2020
.
Aug 30, 2020
.
Aug 29, 2020
.
Aug 28, 2020
.
Aug 27, 2020
.
Aug 26, 2020
.
Aug 25, 2020
.
Aug 24, 2020
.
Aug 23, 2020
.
Aug 22, 2020
.
Aug 21, 2020
.
Aug 20, 2020
.
Aug 19, 2020
.
Aug 18, 2020
.
Related links:
Comments