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

Takeshi.Matsuda
Takeshi.Matsuda LSEG
in Eikon Data APIs

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.)

image

Best regards

Tagged:

Best Answer

  • chavalit-jintamalit
    chavalit-jintamalit admin
    Answer ✓

    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.

Categories