import local file in xlsx extension ?
8 years 7 months ago #1501
by messi
import local file in xlsx extension ? was created by messi
dose I2 support import local file in xlsx extension now ?
Thanks
Thanks
Please Log in or Create an account to join the conversation.
8 years 7 months ago #1502
by Frank
Are you Give I2L 5 stars!
Are you Please lets us know how to improve it!
Replied by Frank on topic import local file in xlsx extension ?
It used to, but it was removed as reading from a .xlsx was too unstable and dependent of the platform (what could be fine in windows wasn't working as great in a mac).
The plugin currently import and exports from .csv, and given that this format opens automatically in excel and most other spreadsheet software, then, the workflow is the same as working with a .xlsx file. (except that you loose the color and layout information you may have set in excel).
But aside that, it is as simple as double-clicking a .csv and it will open in Excel (no need to "Import from text").
For using more advanced Spreadsheet features (like formulas, colors, layout, etc) the plugin encourages you to use Google Spreadsheets. The plugin will even automatically download any change from the spreadsheets after the game is released!
Thanks,
Frank
The plugin currently import and exports from .csv, and given that this format opens automatically in excel and most other spreadsheet software, then, the workflow is the same as working with a .xlsx file. (except that you loose the color and layout information you may have set in excel).
But aside that, it is as simple as double-clicking a .csv and it will open in Excel (no need to "Import from text").
For using more advanced Spreadsheet features (like formulas, colors, layout, etc) the plugin encourages you to use Google Spreadsheets. The plugin will even automatically download any change from the spreadsheets after the game is released!
Thanks,
Frank
Are you Give I2L 5 stars!
Are you Please lets us know how to improve it!
To get the betas as soon as they are ready,
check this out
The following user(s) said Thank You: messi
Please Log in or Create an account to join the conversation.
8 years 7 months ago #1503
by messi
Replied by messi on topic import local file in xlsx extension ?
Thanks for your reply
now my situation is I use Google doc ,but the doc is too big, about 2.4MB .every time it take very long time to download from Google .
When I convert xlsx to csv, the csv contains messy code in some languages
So ,could you help me to fix this problem ?Thanks
now my situation is I use Google doc ,but the doc is too big, about 2.4MB .every time it take very long time to download from Google .
When I convert xlsx to csv, the csv contains messy code in some languages
So ,could you help me to fix this problem ?Thanks
Please Log in or Create an account to join the conversation.
8 years 7 months ago #1504
by Frank
Are you Give I2L 5 stars!
Are you Please lets us know how to improve it!
Replied by Frank on topic import local file in xlsx extension ?
Hi,
One of the features that I'm working on is on Compressing the data (making the upload/download smaller, as well as the size of the localization data in memory). That should help you with this issue. However, this feature will not make it for the final 2.6.6 (Hopefully for 2.6.7 )
In the meantime, if you see weird characters when converting from xlsl to csv, most likely its because of the encoding. Be sure, you are exporting to csv in UTF8 or other major encoding format. And then, be sure to import the csv file using the same encoding. (there is a combo-box when importing the csv file that allows you to pick the encoding format of the file).
That should fix any weird characters you may see.
Hope that helps,
Frank
One of the features that I'm working on is on Compressing the data (making the upload/download smaller, as well as the size of the localization data in memory). That should help you with this issue. However, this feature will not make it for the final 2.6.6 (Hopefully for 2.6.7 )
In the meantime, if you see weird characters when converting from xlsl to csv, most likely its because of the encoding. Be sure, you are exporting to csv in UTF8 or other major encoding format. And then, be sure to import the csv file using the same encoding. (there is a combo-box when importing the csv file that allows you to pick the encoding format of the file).
That should fix any weird characters you may see.
Hope that helps,
Frank
Are you Give I2L 5 stars!
Are you Please lets us know how to improve it!
To get the betas as soon as they are ready,
check this out
Please Log in or Create an account to join the conversation.
8 years 7 months ago #1506
by messi
Replied by messi on topic import local file in xlsx extension ?
Because my I2 google doc has multiple sheets ,it is not convenient to export every single sheet to a csv file ,and the reason of yesterday's messy code is the Microsoft office software ,when I use Google doc to export csv ,it is perfect .
Finally I resolve this problem by write a little google app script tool to combine sheets to one ,then export as csv to local ,then import to I2 prefab ,everything is done
Thanks all the same for your advice .
Finally I resolve this problem by write a little google app script tool to combine sheets to one ,then export as csv to local ,then import to I2 prefab ,everything is done
Thanks all the same for your advice .
Please Log in or Create an account to join the conversation.
Time to create page: 0.194 seconds