Good day.
Is it possible to use a WorkBook created with the Insider Beta Version of Excel as datasource in AppSheet?
Thanks
Gert.
Appsheet can only use cloud-stored data. Does โInsider Beta Version of Excelโ get stored on the same cloud storage as regular Excel?
Why donโt you try it out and see if it works and let us know?
I donโt see why the Excel version could affect anything since the most important thing is where the data is saved.
Microsoft 365 for example:
@Marc_Dillon
@SkrOYC
The xlsx file is on onedrive and works fine with Excel beta version.
The problem I am trying to figure out is, by what is the data served to appsheet. Not knowledgeable on this myself but i am sure appsheet uses something like an excel api to communicate with the workbook to retrieve and save data.
I also think that the api will be based on some version of excel.
The Office insider beta version of office 365 is the newest unreleased version of the suite used by office insiders to test and propose new features.
In the beta version of 365 there are some new powerful formulas, one of them being the lambda() which gives you the ability to define and name your own functions which can be called recursively, with their own parameters.
I have a sheet full of lambda() functions and i tried it on appsheet but get an error on the defined functions.
The same as happens when you try to ooen the file with the released version of office 365.
I dont have enough knowledge of the ins and outs of appsheet so i assume that appsheet uses the latest released version of Excel 365 to communicate with the worksheet.
Maybe my question should be if it is possible to tell appsheet what version of excel 365 to use and if the beta version can then be used also?
Gert.
The excel version you use and everything you talked about applies to the client. It doesnโt affect the data.
Data is fetched server side
Load the sheet blank first, then add the lambda functions, so that Appsheet doesnโt even know about them. Or just steer clear of that completely, I wouldnโt recommend it.
@SkrOYC
Then in this case Appsheet is the client.
And the server is where Appsheet gets the data from.
So how can I get Appsheet to not give an error on the newly defined functions:
Gert
You shouldnโt be using excel on another thing thatโs not just plain range of data or even tables. Thatโs my advice.
You can read more here
Not supported.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |