How can I read Restricted excel using C#? Oledb driver or interop is the best approach?How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?How do I properly clean up Excel interop objects?Proper use of the IDisposable interfaceC# Excel file OLEDB read HTML IMPORTRead password protected excel file using OLEDB in C#C# read open Excel file through OleDbFastest way to read Excel using Interop and save in DataTableWhy not inherit from List<T>?How to read a password protected Excel worksheet with OLEDBConverting Excel to Datatable with OleDB c#
What is this green alien supposed to be on the American covers of the "Hitchhiker's Guide to the Galaxy"?
A scene of Jimmy diversity
What happens if there is no space for entry stamp in the passport for US visa?
Pi 3 B+ no audio device found
what relax command means?
Create Array from list of indices/values
Improve quality of image bars
Why do so many pure math PhD students drop out or leave academia, compared to applied mathematics PhDs?
How to find location on Cambridge-Mildenhall railway that still has tracks/rails?
What would be the safest way to drop thousands of small, hard objects from a typical, high wing, GA airplane?
Jump back to the position I started a search
Is it rude to refer to janitors as 'floor people'?
Operation Unz̖̬̜̺̬a͇͖̯͔͉l̟̭g͕̝̼͇͓̪͍o̬̝͍̹̻
Why do space operations use "nominal" to mean "working correctly"?
Credit card details stolen every 1-2 years. What am I doing wrong?
Is it ethical for a company to ask its employees to move furniture on a weekend?
Is this fuse time-current curve wrong?
Question on Deriving the Product Rule
Why is Google approaching my VPS machine?
Vienna To Graz By Rail
What are "full piece" and "half piece" in chess?
How fast does a character need to move to be effectively invisible?
What were the problems on the Apollo 11 lunar module?
How could a medieval fortress manage large groups of migrants and travelers?
How can I read Restricted excel using C#? Oledb driver or interop is the best approach?
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?How do I properly clean up Excel interop objects?Proper use of the IDisposable interfaceC# Excel file OLEDB read HTML IMPORTRead password protected excel file using OLEDB in C#C# read open Excel file through OleDbFastest way to read Excel using Interop and save in DataTableWhy not inherit from List<T>?How to read a password protected Excel worksheet with OLEDBConverting Excel to Datatable with OleDB c#
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have an excel file which restricted one.When i am using oledb connection not able extract data to the Datatable.Another solution is to use interop, but it is very slow and not recommended.Request you to help to read the restricted excel into a datatable.
c# excel interop oledb
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
add a comment |
I have an excel file which restricted one.When i am using oledb connection not able extract data to the Datatable.Another solution is to use interop, but it is very slow and not recommended.Request you to help to read the restricted excel into a datatable.
c# excel interop oledb
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
Why is it "restricted"? What have you already tried? As is your question is meaningless. Sorry but you need to provide waaaaay more details.
– Ciarán
Mar 26 at 11:26
I am using a web service to download the excel file, the downloaded file is restricted for some user level.I have tried to read the file using OLEDB driver, and getting error external table is not an expected format.But when i am trying with interop able to read the file and the performance is extremely bad. Thanks in advance.
– user1021583
Mar 26 at 12:35
add a comment |
I have an excel file which restricted one.When i am using oledb connection not able extract data to the Datatable.Another solution is to use interop, but it is very slow and not recommended.Request you to help to read the restricted excel into a datatable.
c# excel interop oledb
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
I have an excel file which restricted one.When i am using oledb connection not able extract data to the Datatable.Another solution is to use interop, but it is very slow and not recommended.Request you to help to read the restricted excel into a datatable.
c# excel interop oledb
c# excel interop oledb
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
asked Mar 26 at 9:06
user1021583user1021583
1197 bronze badges
1197 bronze badges
Why is it "restricted"? What have you already tried? As is your question is meaningless. Sorry but you need to provide waaaaay more details.
– Ciarán
Mar 26 at 11:26
I am using a web service to download the excel file, the downloaded file is restricted for some user level.I have tried to read the file using OLEDB driver, and getting error external table is not an expected format.But when i am trying with interop able to read the file and the performance is extremely bad. Thanks in advance.
– user1021583
Mar 26 at 12:35
add a comment |
Why is it "restricted"? What have you already tried? As is your question is meaningless. Sorry but you need to provide waaaaay more details.
– Ciarán
Mar 26 at 11:26
I am using a web service to download the excel file, the downloaded file is restricted for some user level.I have tried to read the file using OLEDB driver, and getting error external table is not an expected format.But when i am trying with interop able to read the file and the performance is extremely bad. Thanks in advance.
– user1021583
Mar 26 at 12:35
Why is it "restricted"? What have you already tried? As is your question is meaningless. Sorry but you need to provide waaaaay more details.
– Ciarán
Mar 26 at 11:26
Why is it "restricted"? What have you already tried? As is your question is meaningless. Sorry but you need to provide waaaaay more details.
– Ciarán
Mar 26 at 11:26
I am using a web service to download the excel file, the downloaded file is restricted for some user level.I have tried to read the file using OLEDB driver, and getting error external table is not an expected format.But when i am trying with interop able to read the file and the performance is extremely bad. Thanks in advance.
– user1021583
Mar 26 at 12:35
I am using a web service to download the excel file, the downloaded file is restricted for some user level.I have tried to read the file using OLEDB driver, and getting error external table is not an expected format.But when i am trying with interop able to read the file and the performance is extremely bad. Thanks in advance.
– user1021583
Mar 26 at 12:35
add a comment |
0
active
oldest
votes
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%2f55353315%2fhow-can-i-read-restricted-excel-using-c-oledb-driver-or-interop-is-the-best-ap%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
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%2f55353315%2fhow-can-i-read-restricted-excel-using-c-oledb-driver-or-interop-is-the-best-ap%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
Why is it "restricted"? What have you already tried? As is your question is meaningless. Sorry but you need to provide waaaaay more details.
– Ciarán
Mar 26 at 11:26
I am using a web service to download the excel file, the downloaded file is restricted for some user level.I have tried to read the file using OLEDB driver, and getting error external table is not an expected format.But when i am trying with interop able to read the file and the performance is extremely bad. Thanks in advance.
– user1021583
Mar 26 at 12:35