kiseki 0 Posted July 22, 2013 Report Share Posted July 22, 2013 Hi guys, does anyone experience that Ubot cannot suddenly detect a row from excel?...for instance it detected the row 0 and its columns then when it comes to row 1 only some columns was detected like only 2 columns and everything is not detected. even though ive checked the excel file all the columns contains everything. Im checking this in the debugger though. Please see the attached file for it... Quote Link to post Share on other sites
UBotDev 276 Posted July 22, 2013 Report Share Posted July 22, 2013 I never had problems with that. If you export Excel file as CSV UBot shouldn't have problems with loading that data to table. Quote Link to post Share on other sites
Marton 48 Posted July 22, 2013 Report Share Posted July 22, 2013 Open the csv in notepad++.The values should be separated by ',' or ';'. Quote Link to post Share on other sites
kiseki 0 Posted July 22, 2013 Author Report Share Posted July 22, 2013 Im sorry my mistake it's not excel it was CSV file... Quote Link to post Share on other sites
UBotDev 276 Posted July 23, 2013 Report Share Posted July 23, 2013 It should work without problems if you have a valid CSV file.; if so, UBot should have the same data in table as Excel does. As Urban said, make sure you are using hte right delimiters. Default column delimiter in UBot is comma "," (you can change that if you want), so all columns should be delimited by it. Delimiter for row is new line "\n", so you should also check that. If you use any of those 2 characters inside a cell as value, that cell content should be surrounded by double quote ". Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.