For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Takeshi.Matsuda avatar image
20 ●0 ●1 ●0

[ Codebook ] How to "read_excel" from Local file & "df.to_Excel to Local file?

Perhaps because CodeBook is a cloud environment, it seems that the method of reading local files is different from Jupyter Notebook.

  1. Since the tkinter library and os library cannot be used in Codebook, it is a problem because the user cannot specify any folder or file whose name changes every day. (I'm looking for "a feature similar to specifying a file to work with using FileSystemDialog" in a Codebook environment.)

  2. I want to automate so that customers do not have to manually download data every time. Look at the figure. I don't want customers to do this kind of operation every time. (I want to realize "automatic processing of Excel file operations" using Pandas or Openpyxl with Codebook as well as Jupyter Notebook.)

Best regards

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
datadl.png (43.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @Takeshi.Matsuda

If the "Local File" means the "Local File on user's computer", I believe that this is not possible.

As you already understand that CodeBook is hosted in cloud.

The files on the CodeBook and the files on the user's computer are totally separated environment.


Is it possible to distribute your Jupyter notebook and launch it under user's local Jupyter Notebook ?

In this case, you can install any Python package and access to local file on the user's computer.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea