Exception while trying to read a stream in ax 7

(0) Share

Report

Posted on by Community Member

Hi, I am getting the following exception "A disk error occurred during a write operation. (Exception from HRESULT: 0x8003001D (STG_E_WRITEFAULT))" while i am trying to read a stream. I got the exception at the Line which is having read font. Can any one help me out?

            FileUpload fileUploadControl     = dialog.formRun().control(dialog.formRun().controlId('Upload'));

            FileUploadTemporaryStorageResult fileUploadResult = fileUploadControl.getFileUploadResult();

 
            memoryStream = fileUploadResult.openResult();
            fileurl=fileUploadResult.getDownloadUrl();
            filename=fileUploadResult.getFileName();
               

            if (fileUploadResult != null && fileUploadResult.getUploadStatus())

            {
                [splitFilepath,splitFilename,splitFileExt] = filenameSplit(filename);
                if ( splitFileExt== '.xls' || splitFileExt== '.csv' )
                {
                    
              
                    using (ExcelPackage Package = new ExcelPackage(memoryStream))

                    {.......

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Martin Dráb 237,961 Most Valuable Professional on at

Like (0)

Report

Is the content really an Excel spreadsheet? It seems that your code will try to create an Excel package even for text files...

If it is, it is the Open XML format (.xlsx) or the old one?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am using the format (.xls) Excel file. I need to read the file of .xls extension. Could you tell me why this exception is occurred?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,961 Most Valuable Professional on at

Like (1)

Report

I don't think you will be able to use the OpenXML API for non-OpenXML files. Either you'll find an API that can work with the old format, or you'll have to use another format.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

So,this is like i can only use .xlsx file in this open XML. Am i right?

Is there anyother way to read a .xls file?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,961 Most Valuable Professional on at

Like (0)

Report

Yes, only .xlsx uses Open XML format. The old formats were something proprietary.

There surely can be found ways to read other formats, but I wouldn't invest time into it. .xlsx is around for more than 12 years and you can export data from .xls to commonly understandable formats if you have to deal with imports of something really old.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, I am exporting data from .xls by converting it into .csv file and updating a table through this .csv file. I have no idea how to read a .xls file.

Was this reply helpful? Yes No

Community site session details

Exception while trying to read a stream in ax 7

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Exception while trying to read a stream in ax 7

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates