Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvote
Accepted
35 1 2 3

[ 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
datadl.png (43.1 KiB)
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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