I found this for opening Excel files in Python: https://www.pythonexcel.com
And here is the Python documentation: https://ignite.apache.org/docs/latest/thin-clients/python-thin-client > On 1 Sep 2021, at 11:23, Karthik Nandagiri > <karthik.nandag...@costrategix.com> wrote: > > > Thank you Stephen for the inputs. > > Please provide me with some examples to load excel data to ignite with python > client, this will help to speed up my development > > The way we use ignite is, start it as an external service with ignite.sh and > provide the xml config path, and then create tables and load data . > > > Thank you > Regards > Karthik N > > On Wed, Sep 1, 2021 at 1:49 PM Stephen Darlington > <stephen.darling...@gridgain.com <mailto:stephen.darling...@gridgain.com>> > wrote: > I would look at using the Python thin client. There are libraries for reading > Excel and parsing JSON. There’s a good chance that there are Java libraries, > too, but I’ve not used them. > > > On 1 Sep 2021, at 07:54, Karthik Nandagiri > > <karthik.nandag...@costrategix.com > > <mailto:karthik.nandag...@costrategix.com>> wrote: > > > > Hi Team > > > > We have a requirement where a client(user) will provide me data in any of > > the formats, csv, excel or json. > > Now, we need to load this data into ignite table(table is created). For csv > > we are using sqlline tool with copy from command. > > Is there a mechanism to load excel and json data as well? As we won't be > > having access to clients' RDBMS, we are provided the data in any of the > > file formats mentioned above. > > > > Regards > > Karthik N > >
