Error Connecting To Excel
Hi,
I am new to Bartender and after looking at some examples I tried connecting my own Excel file as DB to the label I have made but I am not able to connect to it. The error says Database not in expected format.
Can you please tell what format should I keep the excel worksheet and cell. Currently I have kept 6 columns in text format and 2 columns in number format.
Looking forward to some assistance.
I am new to Bartender and after looking at some examples I tried connecting my own Excel file as DB to the label I have made but I am not able to connect to it. The error says Database not in expected format.
Can you please tell what format should I keep the excel worksheet and cell. Currently I have kept 6 columns in text format and 2 columns in number format.
Looking forward to some assistance.
0
-
A. Close your excel file before trying to open in BarTender
B. I usually save the files as .xls, even if using Excel 2007 or 2010 where the defaults is .xlsx.
C. If all else fails, copy and paste your data into a fresh excel chart and re-save.
D. Also watch this video if still having issues http://www.seagullscientific.com/aspx/training-video-(reading-data-from-database).aspx0 -
[quote name='nRyder' timestamp='1318596005' post='805']
A. Close your excel file before trying to open in BarTender
B. I usually save the files as .xls, even if using Excel 2007 or 2010 where the defaults is .xlsx.
C. If all else fails, copy and paste your data into a fresh excel chart and re-save.
D. Also watch this video if still having issues http://www.seagullscientific.com/aspx/training-video-(reading-data-from-database).aspx
[/quote]
Dear Ryder,
Thank you for your help, it worked. I have to keep the excel file in .xls format
Thanks,
G patel0
请先登录再写评论。
评论
2 条评论