Page 1 of 1
Using Excel for saves
Posted: Tue Oct 16, 2012 12:17 pm
by greasontim
So I started playing around with vb.net using Excel for save files.
But I keep having a small issue.
Excel, keeps loading up asking for a password. (Passworded to stop people from screwing with the info)
I don't want it to load up at all, any way to fix this?
Re: Using Excel for saves
Posted: Tue Oct 16, 2012 1:37 pm
by Jackolantern
If a password has ended up on your Excel file, you can remove it by following the instructions
here. If the password has something to do with .NET-to-Excel automation, I am not sure, as I have not done any Office automation since VB6.
Re: Using Excel for saves
Posted: Wed Oct 17, 2012 3:50 pm
by hallsofvallhalla
i thought there was an excel library you could use to parse the data directly in the file. If you are calling the file then the excel parser is needed.
Re: Using Excel for saves
Posted: Wed Oct 17, 2012 5:40 pm
by theweirdn8
"Why you no use sql-lite?"
Re: Using Excel for saves
Posted: Wed Oct 17, 2012 6:01 pm
by hallsofvallhalla
I would agree a DB would be easier but if it is something he is wanting to just easily deploy a text based file solution may be easier.
Re: Using Excel for saves
Posted: Wed Oct 17, 2012 7:41 pm
by Jackolantern
I do have to agree on SQL-Lite. SQL-Lite basically is a simple, text file-based solution that can easily be deployed with the application if needed. But it is much more advanced than simply using straight flat file or CSV files since it abstracts away much of the parsing and gives you a pretty decent SQL-like experience.
Re: Using Excel for saves
Posted: Sat Oct 20, 2012 11:30 pm
by greasontim
Already using a .txt file save system, but I'm trying to look into a better save method where they can't edit the character files.
So which would you suggest then?
DB = SQL-lite
or
excel
Re: Using Excel for saves
Posted: Sun Oct 21, 2012 12:24 am
by Jackolantern
I am not sure how secure SQL-lite is. You may just want to look into encrypting your IO to a flat file.
Re: Using Excel for saves
Posted: Sun Oct 21, 2012 12:36 am
by greasontim
Jackolantern wrote:I am not sure how secure SQL-lite is. You may just want to look into encrypting your IO to a flat file.
Any suggestions on to do that?
My encrypting knowledge with vb.net is non-existent
Re: Using Excel for saves
Posted: Sun Oct 21, 2012 12:50 am
by Jackolantern
Maybe
this could be useful
