Skip to content

(issue 900): implemented Range.add_plot() and add_table() #926

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
alixdamman wants to merge 8 commits into
base: master
Choose a base branch
from
Open

(issue 900): implemented Range.add_plot() and add_table() #926

Changes from 1 commit
Commits
Show all changes
8 commits
Select commit Hold shift + click to select a range
e11147f
implemented Range.make_plot()
alixdamman Mar 29, 2021
34ec5a4
replaced position argument by data_source.
alixdamman Jan 18, 2022
a175544
renamed make_plot() as add_plot()
alixdamman Jan 18, 2022
8c00ba0
implemented Range.add_table()
alixdamman Jan 18, 2022
4f9febc
>> updated open_excel() example
alixdamman Feb 8, 2022
3055aea
updated tutorial_IO.ipynb -> added an example for add_table()
alixdamman May 23, 2022
3a4166a
updated unittest function test_add_plot()
alixdamman May 23, 2022
759547c
tutorial: added section Excel Plot
alixdamman May 23, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
>> updated open_excel() example
  • Loading branch information
@alixdamman
alixdamman committed May 23, 2022
commit 4f9febc13118b98d8e6f728b425eeef09102be4d
20 changes: 16 additions & 4 deletions larray/inout/xw_excel.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -815,16 +815,28 @@ def open_excel(filepath=None, overwrite_file=False, visible=None, silent=None, a

>>> # to create a new Excel file, argument overwrite_file must be set to True
>>> with open_excel('excel_file.xlsx', overwrite_file=True) as wb: # doctest: +SKIP
... # create a new sheet 'arr' and dump the array 'arr' starting at cell A1
... wb['arr'] = arr.dump()
... wb['arr']['A6'].add_table()
... wb['arr']['G1'].add_plot('A1', title='simple graph')
...
... # dump array 'arr2' starting at cell F1
... wb['arr']['F1'].add_table(arr2)
...
... # add a plot with left top corner anchored to cell A6 and
... # using data in range A1:D4
... wb['arr']['A6'].add_plot('A1:D4', title='simple graph')
...
... # add a plot with left top corner anchored to cell F6 and
... # using data in range F1:H3 where H3 is deduced automatically
... wb['arr']['F6'].add_plot('F1', title='second simple graph')
...
... save the workbook
... wb.save()

read array from an Excel file

>>> with open_excel('excel_file.xlsx') as wb: # doctest: +SKIP
... arr2 = wb['arr'].load()
>>> arr2 # doctest: +SKIP
... arr3 = wb['arr'].load()
>>> arr3 # doctest: +SKIP
a\b b0 b1 b2
a0 0 1 2
a1 3 4 5
Expand Down