Greetings, Sure you can use a spreadsheet without column headers.
Reading the below, sounds like you are opening the spreadsheet with "direct update" set. Direct update allows you to write back to the source spreadsheet -but it would have this behavior of creating a column to do so. I'd suggest reopening the file with the DataStation - see if there's any checkboxes set - if there are, uncheck them. Give Support a ring if you have any questions on this: 866 653-5105 Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign up for my weekly webinar! <http://www.bostonworkstation.com/customer_center/special_events.aspx> LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [email protected] [mailto:[email protected]] Sent: Friday, March 19, 2010 10:57 AM To: Talk Subject: [talkbws] Simply question....for a beginner I am new to BWS and was asked to create a simple script. I don't use the tool often, so the basics are slowly coming back to me - when you don't use, you do loose. Does the "source" spreadsheet need to have column headers? The excel spreadsheet I am working with for this script doesn't, so I thought I could use the D("1"), D("2)", etc. as designation - instead of column headers. This works for the first cycle of record processing, but once the Status is updated, it shifts the first column to be the second column and the scripts goes into a loop because what I am checking in D("1") is blank, instead of a the numbers we are validating. Example below is what the datastation looks like when the first record is processing - note 6 columns: Example below is what the datastation looks like when the second record is processed - note 7 columns: Amy Sobczak St. Michael's Hospital, 900 Illinois Avenue, Stevens Point WI 54481 | phone: 715.342.7629 | email: [email protected] ________________________________ CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipient(s) named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender at the electronic mail address noted above and destroy all copies of this communication and any attachments. Thank you for your cooperation. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
<<image001.jpg>>
<<image002.jpg>>
