Error Occur Cannot interpret token '=' at position 9 in excel

Help
1

Hi Team,

I am working on an excel file, that is password protected. So i am reading that file by using Read Range Workbook.
As i am having multiple rows having similar data so i am using join for making it as a single row with all the data . It was working fine if the excel is not password protected but it is not working on my currect excel having dropdowns. I am getting error “Cannot interpret token ‘=’ at position 9”.
Attached is the .xaml file and sample attachment file.
Please help.
Entwurf nach Vorshlag Fa.RailTec.xlsx (982.8 KB)
Main.xaml (20.8 KB)

2

Dear @NitikaTyagi,
This code had problem:
String.Join(“;”,(from line in DTRailTec.Select(“Wagennr.='”+item(“Wagennr.”).ToString+“'”).CopyToDataTable() select Convert.ToString(line(“Arbeit”))).ToArray())

Just change to
String.Join(“;”,(from line in DTRailTec.Select(“[Wagennr.]='”+item(“Wagennr.”).ToString+“'”).CopyToDataTable() select Convert.ToString(line(“Arbeit”))).ToArray())

3

Hi Chientran,

Is that working in your system as i now i am getting new error-

The expression contains an invalid string constant: '[Wagennr.]=’25804365111-0’."

Thanks in advance.

Regards,

Nitika

DISCLAIMER: The information transmitted, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you receive this email by mistake, please advise the sender and delete it immediately. Email transmission cannot be guaranteed to be secure, or error free as information could be intercepted, corrupted, lost or destroyed as a result of the transmission process. Views or opinions presented in this email are solely those of the author and do not necessarily represent those of the Company. Through this e-mail, no employee or agent is authorized to conclude/commit any new or incidental terms, which are not part of the original contract with the client or vendor, other than by way of duly executed and signed amendment contract between the parties in accordance with the agreed protocol of the contract. Please be aware that the Company monitors e-mail communications through our networks for regulatory compliance purposes. NIIT Technologies Limited and its related entities consider the privacy of its clients to be of utmost importance and works to protect it. The Privacy Policy of the Company can be accessed from our website www.niit-tech.com.

4

oops sorry i was using a wrong operator in the last query.
But For this
String.Join(“;”,(From line In DTRailTec.Select(“’[Wagennr.]=’”+item(“Wagennr.”).ToString+“’”).CopyToDataTable() Select Convert.ToString(line(“Schadcode”))).ToArray())

I am getting this error–Syntax error: Missing operand after ‘[Wagennr.]’ operator.",

Can you please suggest where i have to put the operand.

5

@NitikaTyagi
sr I am not online much.

(“’[Wagennr.]=’” → wrong quotation. Review pls.