Hi, I use password when I export my theme. I want to know if it is possible to put Spreadsheets on specific folder to give possibilty to user to edit the .csv with ATVO exported with mp ?

You can use the External Filepath property of the spreadsheet (or any other content file). The theme will look for a spreadsheet in that location first and will use it if it exists. If it does not exist, it will use the spreadsheet embedded in the theme. I believe this path must be a full (absolute) path, not relative to the theme.

Thanks, I try with full "absolute" path and it is ok.

Hi Nick,
I want to use spreadsheet for variable text to put and edit for external commentator or specialist. My idea is to let to user to edit a spreadsheet with: name,fonction for each row.

First I think I can easily link that to a dropdown to select row number 1 and show each column in labels. But I don't know how use spreadsheet without driver ref !

Does it possible ? Can you give me a starting solution?

Thx

When you add a spreadsheet to your theme, it also becomes available as a Data Set. Just select the spreadsheet as your dataset for a Widget, and then for the labels in that widget you can select each column as a data binding. The widget will show the 1st row by default, but you can change that by using the Data Offset. Or you can make it into a ticker and it will show all rows.

Thanks

I tried the External Filepath Function with absolute und relative paths but it does not work :(

Example for absolute:
C:\Users\Neldrion\Documents\Appgineer.in\Theme Editor\Themes\SkippyCup\Content\Spreadsheets

The file has exactly the same nameDo I need another formatting?

Error Log says:
Warning: the External Filepath property was set but the file was not found. The external file path is ignored and the embedded file was loaded. External filepath: C:\Users\Neldrion\Documents\Appgineer.in\Theme Editor\Themes\SkippyCup\Content\Spreadsheets

Yeah lol I found the error :)

I forgot to add the filename itself at the end of the path.

Silly mistake, took me 45 minutes of my lifetime :)

It works perfectly fine now.

Perfect, I spend lot of time to find some simply mistake ;)

Just for information, I use it because I use password when I compil my ATVO. If you put a user filepath it will be difficult to your user to use it! And Without the filepath It go at this place directly ;)

Is it possible to do a little script to reload a spreadsheet (I don't want that it is always read, just if we change some parts). I hope use a button and a script to do that. But how?

You can call "spreadsheet.Parse()" to update it.

Thanks, I have to make some research because I can make script but only by combine exemple :(

I think I have to find my spreadsheet:
var sheet = theme.Spreadsheets.Find("sheet.txt");

And then:
spreadsheet.Parse(sheet);

?

Nearly:

var sheet = item.Theme.Spreadsheets.Find("sheet.csv");
sheet.Parse();

Thanks a lot

I make test, the information when I use Cash Data is:
sheet.csv The embedded theme file was replaced by an external file successfully.

And my data are update

With script I have got the same information but data are not update in theme !

Certainly need to read each line and separate by scripts each column in each row.

Nick, any idea why if file is replaced the information inside are not update in theme?

Try turning off Cache Data, I think it will keep the old values in memory if you leave that on.

If I disable Cache DATA, the system allready reading data each update as you wrote in description (and it is working nice). It is the reason why I try to do it manually to prevent some useless processor charge

Cache Data is not meant to be reading the spreadsheet every update when you are connected to iRacing. It should only do that when you are not connected to iRacing, and then it will update once per second. This is so people can use spreadsheet bindings without iRacing connection, otherwise the bindings would never work.

When connected to iRacing, the spreadsheet should be static by default unless you force it to update. You can force it to update with the above script (run Parse), or by changing any property of the spreadsheet (which I think is also only possible by a script).

Ok, I do my last test without iRacing connected, sorry for that ! I try again ;)

Perfect ! It is OK
Thanks