Feature request: read excel from dynamic data source path in input form

[uyoufu]

I have the following requirement:

During the user usage stage(input form state), the user can be able to decide from which file to read excel data.

The expected code is like this:

filename = ? 
#read M from filename.txt@R1C1:R2C2 TYPE=R SEP=','

During usage, the user can input the data path and then perform calculations.

Can the existing functionality support such a requirement?

If not, hope this feature can be implemented, as it would make the calculation book much more flexible and reusable

[Proektsoftbg]

It is not possible to enter filename as free text.
What you can do is to define a list with options that the user can choose from by using html <select> element and then #if block to read the respective file.

[uyoufu]

Well, thanks!

[uyoufu]

Is there any way to extend a macro or add a custom macro in core?
I have a web calcpad, and want to read data from user in web.

just like this:

[Proektsoftbg]

OK. I see now. Maybe we can make something like:
#read M from ? ...
simlar to input fields and the program to generate an "upload" button on input and then use the uploaded file contents.
I will think a little more about it.

[imartincei]

Adding string variables should fix the issue of not being able to input a filepath dynamically, as long as we could figure out how to substitute them in the correct order. A file picker to get a path into an input field is all that would be needed here once we have this.

I also have loading files using include and read from URLs working, including with auth. Let's touch base on this @Proektsoftbg to see if we can get this into the main version, as it will make Calcpad way more extensible immediately without many other features.

Note that you would need a middleman server to handle to auth aspect, but I have an example of how I did this. You would need some coding experience to make it work though. Public URLs will work out of the box.