How to derive big tables from Excel sheets?
It's as simple as this 1-2-3 method. Provided with live example.
[title]Step 1 - Save your Excel sheet[/title]
Save data using the specific CSV (Comma-Separated Values) format. Excel will complain that part of the information will be lost, but you will accept this as a matter of fact.
[title]Step 2 - Open the saved file in atext editor[/title]
Use the Notepad to do that, or any text editor you have ready to do the job.
Select all the text and activate the command to copy data in the clipboard.
[title]Step 3 - Copy data in a YACS page[/title]
Connect to your favorite YACS server, and create a page. In the edit form place some tags to create a table and to declare CSV data.
Paste your data just between these tags, and hit the Submit button to transfer this to your server. Done!
[title]Want more details?[/title]
Check the help page we have on codes used for tables.
You can also check an live example of this feature at zaniroli.com. General results of a regularity race have been cut and paste from Excel to the server in order to build a nice page. It's in French, but you will get the idea...
Save data using the specific CSV (Comma-Separated Values) format. Excel will complain that part of the information will be lost, but you will accept this as a matter of fact.
[title]Step 2 - Open the saved file in atext editor[/title]
Use the Notepad to do that, or any text editor you have ready to do the job.
Select all the text and activate the command to copy data in the clipboard.
[title]Step 3 - Copy data in a YACS page[/title]
Connect to your favorite YACS server, and create a page. In the edit form place some tags to create a table and to declare CSV data.
[table]
[csv]
<-- paste your CSV data exported from Excel here
[/csv]
[/table]
Paste your data just between these tags, and hit the Submit button to transfer this to your server. Done!
[title]Want more details?[/title]
Check the help page we have on codes used for tables.
You can also check an live example of this feature at zaniroli.com. General results of a regularity race have been cut and paste from Excel to the server in order to build a nice page. It's in French, but you will get the idea...