How to read arabic text contents from an excel sheet in BluePrism?
I am new to BluePrism and trying to read Arabic from an Excel sheet. But when I open collection process it shows question marks instead of showing Arabic characters. I tried to write this data into another sheet but it prints the same question mark rather Arabic.
excel blueprism arabic-support
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
add a comment |
I am new to BluePrism and trying to read Arabic from an Excel sheet. But when I open collection process it shows question marks instead of showing Arabic characters. I tried to write this data into another sheet but it prints the same question mark rather Arabic.
excel blueprism arabic-support
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
I am not sure if BP supports Arabic. Can you describe exactly what do you want to achieve? Move text between Excel Sheets?
– Marek Stejskal
Nov 13 '18 at 17:31
I want to take this arabic text and will login an application in browser and save there.
– Tahir Akram
Nov 13 '18 at 22:25
add a comment |
I am new to BluePrism and trying to read Arabic from an Excel sheet. But when I open collection process it shows question marks instead of showing Arabic characters. I tried to write this data into another sheet but it prints the same question mark rather Arabic.
excel blueprism arabic-support
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
I am new to BluePrism and trying to read Arabic from an Excel sheet. But when I open collection process it shows question marks instead of showing Arabic characters. I tried to write this data into another sheet but it prints the same question mark rather Arabic.
excel blueprism arabic-support
excel blueprism arabic-support
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
asked Nov 13 '18 at 16:00
Tahir AkramTahir Akram
1,83194063
1,83194063
I am not sure if BP supports Arabic. Can you describe exactly what do you want to achieve? Move text between Excel Sheets?
– Marek Stejskal
Nov 13 '18 at 17:31
I want to take this arabic text and will login an application in browser and save there.
– Tahir Akram
Nov 13 '18 at 22:25
add a comment |
I am not sure if BP supports Arabic. Can you describe exactly what do you want to achieve? Move text between Excel Sheets?
– Marek Stejskal
Nov 13 '18 at 17:31
I want to take this arabic text and will login an application in browser and save there.
– Tahir Akram
Nov 13 '18 at 22:25
I am not sure if BP supports Arabic. Can you describe exactly what do you want to achieve? Move text between Excel Sheets?
– Marek Stejskal
Nov 13 '18 at 17:31
I am not sure if BP supports Arabic. Can you describe exactly what do you want to achieve? Move text between Excel Sheets?
– Marek Stejskal
Nov 13 '18 at 17:31
I want to take this arabic text and will login an application in browser and save there.
– Tahir Akram
Nov 13 '18 at 22:25
I want to take this arabic text and will login an application in browser and save there.
– Tahir Akram
Nov 13 '18 at 22:25
add a comment |
2 Answers
2
active
oldest
votes
I tried to use the Get Cell Value command and that worked well with Arabic, which lead me to believe the problem isn't with Blue Prism as a whole, but only in the way the Get Range Collection is built.
If you have a look at the VB.NET code behind the action, you see that the BP developers first copy the range into clipboard and then parse the clipboard contents into the collection. That's where the problem most likely occurs.
A quick workaround would be not using the Get Range as Collection at all and use just the Get Cell Value instead, longer workaround would be modifying the Get Range as Collection action.
I can see two options for the longer workaround as well. Either you figure out the problem with the way the clipboard parsing works and fix it, or you change the logic to fill the DataTable directly (for each row and for each column set cell value to Table). The performance will be worse, but it will work).
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
add a comment |
Probably you need to install the Font on your machine and get the Worksheet as a collection. Or maybe Translate all in English, get it and then translate it in Arabic Again, Or maybe read cell by cell if entire collection isn't working.
It would be helpful to have the worksheet as example.
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53284875%2fhow-to-read-arabic-text-contents-from-an-excel-sheet-in-blueprism%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I tried to use the Get Cell Value command and that worked well with Arabic, which lead me to believe the problem isn't with Blue Prism as a whole, but only in the way the Get Range Collection is built.
If you have a look at the VB.NET code behind the action, you see that the BP developers first copy the range into clipboard and then parse the clipboard contents into the collection. That's where the problem most likely occurs.
A quick workaround would be not using the Get Range as Collection at all and use just the Get Cell Value instead, longer workaround would be modifying the Get Range as Collection action.
I can see two options for the longer workaround as well. Either you figure out the problem with the way the clipboard parsing works and fix it, or you change the logic to fill the DataTable directly (for each row and for each column set cell value to Table). The performance will be worse, but it will work).
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
add a comment |
I tried to use the Get Cell Value command and that worked well with Arabic, which lead me to believe the problem isn't with Blue Prism as a whole, but only in the way the Get Range Collection is built.
If you have a look at the VB.NET code behind the action, you see that the BP developers first copy the range into clipboard and then parse the clipboard contents into the collection. That's where the problem most likely occurs.
A quick workaround would be not using the Get Range as Collection at all and use just the Get Cell Value instead, longer workaround would be modifying the Get Range as Collection action.
I can see two options for the longer workaround as well. Either you figure out the problem with the way the clipboard parsing works and fix it, or you change the logic to fill the DataTable directly (for each row and for each column set cell value to Table). The performance will be worse, but it will work).
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
add a comment |
I tried to use the Get Cell Value command and that worked well with Arabic, which lead me to believe the problem isn't with Blue Prism as a whole, but only in the way the Get Range Collection is built.
If you have a look at the VB.NET code behind the action, you see that the BP developers first copy the range into clipboard and then parse the clipboard contents into the collection. That's where the problem most likely occurs.
A quick workaround would be not using the Get Range as Collection at all and use just the Get Cell Value instead, longer workaround would be modifying the Get Range as Collection action.
I can see two options for the longer workaround as well. Either you figure out the problem with the way the clipboard parsing works and fix it, or you change the logic to fill the DataTable directly (for each row and for each column set cell value to Table). The performance will be worse, but it will work).
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
I tried to use the Get Cell Value command and that worked well with Arabic, which lead me to believe the problem isn't with Blue Prism as a whole, but only in the way the Get Range Collection is built.
If you have a look at the VB.NET code behind the action, you see that the BP developers first copy the range into clipboard and then parse the clipboard contents into the collection. That's where the problem most likely occurs.
A quick workaround would be not using the Get Range as Collection at all and use just the Get Cell Value instead, longer workaround would be modifying the Get Range as Collection action.
I can see two options for the longer workaround as well. Either you figure out the problem with the way the clipboard parsing works and fix it, or you change the logic to fill the DataTable directly (for each row and for each column set cell value to Table). The performance will be worse, but it will work).
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
answered Nov 16 '18 at 9:28
Marek StejskalMarek Stejskal
1,8401222
1,8401222
add a comment |
add a comment |
Probably you need to install the Font on your machine and get the Worksheet as a collection. Or maybe Translate all in English, get it and then translate it in Arabic Again, Or maybe read cell by cell if entire collection isn't working.
It would be helpful to have the worksheet as example.
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
add a comment |
Probably you need to install the Font on your machine and get the Worksheet as a collection. Or maybe Translate all in English, get it and then translate it in Arabic Again, Or maybe read cell by cell if entire collection isn't working.
It would be helpful to have the worksheet as example.
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
add a comment |
Probably you need to install the Font on your machine and get the Worksheet as a collection. Or maybe Translate all in English, get it and then translate it in Arabic Again, Or maybe read cell by cell if entire collection isn't working.
It would be helpful to have the worksheet as example.
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
Probably you need to install the Font on your machine and get the Worksheet as a collection. Or maybe Translate all in English, get it and then translate it in Arabic Again, Or maybe read cell by cell if entire collection isn't working.
It would be helpful to have the worksheet as example.
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
answered Nov 24 '18 at 16:07
Stefano.MaffulloStefano.Maffullo
414116
414116
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53284875%2fhow-to-read-arabic-text-contents-from-an-excel-sheet-in-blueprism%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I am not sure if BP supports Arabic. Can you describe exactly what do you want to achieve? Move text between Excel Sheets?
– Marek Stejskal
Nov 13 '18 at 17:31
I want to take this arabic text and will login an application in browser and save there.
– Tahir Akram
Nov 13 '18 at 22:25