nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Excel to ITable in arcgis soe 10.2.2

mohannainar2

I am trying to convert excel to ITable in ArcGIS (10.2.2) SOE. I am using the below code for converting.

Type factoryType = Type.GetTypeFromProgID( "esriDataSourcesOleDB.ExcelWorkspaceFactory");

IWorkspaceFactory workspaceFactory = (IWorkspaceFactory)Activator.CreateInstance(factoryType);

IWorkspace workspace = workspaceFactory.OpenFromFile(@E:\apps\DevelopmentArea\test.xls, 0);

IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)workspace;

ITable table = featureWorkspace.OpenTable("Sheet1$");

I am getting the error in OpenfromFile method , arcgis server and the SOE projects are in same system.

Error message : Exception from HRESULT: 0x80040213

I checked in the net i could find any help. Kindly provide your suggestion

Find more posts tagged with

Accepted answers

All comments

mohannainar2

Thanks for the information .

I identified the arcgis user and gave the full permission , still i am facing same error mrssage.

nicogis

the user that impersonation arcgis server 'soe' (see ArcGIS for Server Installation Guide - The ArcGIS Server account ) is arcgis server account.

if you use code in console you are using the current user.

mohannainar2

I checked the ' folder security' Everyone is having full access . I am not sure how to set it for 'arcgis' user , can you tell me how to do that.

The same code I wrote in console application it worked for me , the only problem I am facing in ArcGIS soe . In console application I added the below three lines of code.

RuntimeManager.Bind(ProductCode.Desktop);
ESRI.ArcGIS.esriSystem.IAoInitialize ao = new ESRI.ArcGIS.esriSystem.AoInitialize();
ao.Initialize(ESRI.ArcGIS.esriSystem.esriLicenseProductCode.esriLicenseProductCodeStandard);

I tried adding the above three lines in ArcGIS soe but no use it did not worked.

nicogis

Has the user 'arcgis' privileges ntfs open file test.xls ?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.