How to open Excel file in C# in Linux

kenankocer · January 24, 2022, 5:40pm

Hi vladimir.litvinchik,

I am writing to point out this record.

We’re using groupdocs viewer 21.7.0. We create an application based on GitHub - groupdocs-viewer/GroupDocs.Viewer-for-.NET-UI: UI - User Interface for GroupDocs.Viewer for .NET document viewer and automation API.
We are getting an error that we cannot open Excel files. The error screen is as follows.
When I run the same project in windows environment, I do not get an error for the same excel document. Splits into pages and lists pages. But in the linux environment, the same project and excel document are returning with an error. I am sending a detailed explanation and preparing it as an attachment. Can you help me?Excel Error Group Doc.zip (828.9 KB)

vladimir.litvinchik · January 24, 2022, 8:54pm

@kenankocer

Can you please check which version of libgdiplus you are installing? You can check libgdiplus version by typing apt-get -s install libgdiplus. The version should be 6.0.1 or later.

In case the version of libgdiplus is 6.0.1 please prepare the sample application that we can use to reproduce the issue at our side. Here is sample_app.zip (3.0 KB) that contains Dockerfile. You can run the attached app in Docker by typing

docker build -t groupdocs-viewer:viewer-sample .
docker run -it --rm -v ${pwd}/output:/app/output groupdocs-viewer:viewer-sample

Please also check PDF to PNG conversion issue on CentOS 7 - #14 by vladimir.litvinchik for more details about libgdiplus.

kenankocer · January 25, 2022, 8:09am

Hello vladimir.litvinchik

libgdiplus version is 6.0.5.

libgdiplus is already the newest version (6.0.5-0xamarin1+ubuntu2004b1)

The dockerfile you sent is the same as the dockerfile we have.

Since there is no function that gives the error in the example project you sent by saying that the excel file is working in Linux, it is normal that it works without an error. But the function giving error is as follows. These functions are the codes of the project in the URL below that you sent us.

It is the method in the ViewerController class under Controllers in the Viewer.UI.Api in this project.

Attached is the function that gives an error as in the document I sent you.
Error Screen Picture.zip (246.1 KB)

I checked the link you sent. libgdiplus version is 6.0.5. because the problem is different. PDF to PNG conversion issue on CentOS 7 - #14 by vladimir.litvinchik

[HttpGet]
        public async Task<IActionResult> LoadDocumentDescription(string ep)
        {
            try
            {
                //string storagePath = Path.Combine(new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory).Parent.FullName, "MyStaticFiles");
                //string filepath = string.Format("{0}\\{1}", storagePath, ep + ".png");

                DocumentInfo documentDescription =
                    await _viewer.GetDocumentInfoAsync(ep, "");

                var result = new LoadDocumentDescriptionResponse
                {
                    Guid = ep,
                    PrintAllowed = documentDescription.PrintAllowed,
                    Pages = documentDescription.Pages.Select(p => new PageDescription
                    {
                        Width = p.Width,
                        Height = p.Height,
                        Number = p.Number,
                        SheetName = p.Name,
                    }).ToList()
                };

                return OkJsonResult(result);
            }
            catch (Exception ex)
            {
                if (ex.Message.Contains("password", StringComparison.InvariantCultureIgnoreCase))
                {
                    var message = string.IsNullOrEmpty("")
                            ? "Password Required"
                            : "Incorrect Password";

                    return ForbiddenJsonResult(message);
                }

                return ErrorJsonResult(ex.Message);
            }
        }

vladimir.litvinchik · January 25, 2022, 5:36pm

@kenankocer

Since you’re using GroupDocs.Viewer 21.7 please make sure to reference SkiaSharp.NativeAssets.Linux.NoDependencies 2.80.2.

kenankocer · January 26, 2022, 6:30am

Hi,

Although the packages are already installed in this way, groupdocs gives the error I showed above in the LoadDocumentDescription(string ep) method when opening excel in linux.Packages.png (4.6 KB)

vladimir.litvinchik · January 26, 2022, 6:54pm

@kenankocer

Thank you for the response. We’ll try to reproduce this issue and will update you as soon as we have any new information.

kenankocer · January 28, 2022, 1:26pm

Hi @vladimir.litvinchik

Our customers use the application in a live environment. That’s why it’s important to us. I wanted to ask if there is any progress.

Thanks for be interested.

vladimir.litvinchik · January 28, 2022, 2:32pm

@kenankocer

Unfortunately, I can’t reproduce this issue when running it in Docker. Here are the steps that I’ve performed to reproduce the issue:

Cloned the repository git clone https://github.com/groupdocs-viewer/GroupDocs.Viewer-for-.NET-UI.git
Removed .git and .github folders
Removed GroupDocs.Viewer.UI.Cloud.Api.Sample and GroupDocs.Viewer.UI.SelfHost.Api.Service.Sample in the samples folder
Updated the following lines in build/dependencies.props file
- <GroupDocsViewer>22.1.1</GroupDocsViewer> to
  <GroupDocsViewer>21.7.0</GroupDocsViewer>
- <SkiaSharpNativeAssetsLinuxNoDependencies>2.80.3</SkiaSharpNativeAssetsLinuxNoDependencies> to <SkiaSharpNativeAssetsLinuxNoDependencies>2.80.2</SkiaSharpNativeAssetsLinuxNoDependencies>
Added Excel files to samples\GroupDocs.Viewer.UI.Sample\Files\ folder
Added .dockerignore to the root folder
Placed Dockerfile in samples\GroupDocs.Viewer.UI.Sample\
Built image from the root folder by running docker build -f samples/GroupDocs.Viewer.UI.Sample/Dockerfile -t groupdocs-viewer-ui:sample-app .
Started the container with docker run -d -p 8080:80 --name viewer-demo groupdocs-viewer-ui:sample-app
Navigated to http://localhost:8080/viewer in a browser
Opened Excel files

I’m attaching the files and sample app:

dockerfiles.zip (1.2 KB)
viewer-ui.zip (810.2 KB)

Can you please try running the attached app with your file in Docker and confirm that you can reproduce the issue?

kenankocer · February 9, 2022, 6:24am

Hi Vladimir.litvinchik,

When we synchronized our project with the project you sent, we solved the excel problem. But there is a situation like this, in the project you sent, it loads all of the documents with more than 2 pages or sheets as 2 pages and shows them as 2 pages. How can we fix this?error1.png (21.2 KB)

vladimir.litvinchik · February 9, 2022, 7:59am

@kenankocer

Thank you for attaching the screenshot with the error. This is evaluation limitation, the license should be set. You can copy a license (.lic) file to samples\GroupDocs.Viewer.UI.Sample\ folder, then add it to the output directory in the GroupDocs.Viewer.UI.Sample.csproj file

  <ItemGroup>
    <None Update="GroupDocs.Viewer.lic">
      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
    </None>
  </ItemGroup>

And set a path to license file in samples\GroupDocs.Viewer.UI.Sample\Startup.cs:

services
    .AddControllers()
    .AddGroupDocsViewerSelfHostApi(config =>
    {
        config.SetLicensePath("GroupDocs.Viewer.lic");
    })
    .AddLocalStorage("./Files")
    .AddLocalCache("./Cache");

Rebuild the Docker image and try running the container again. In case the license is properly set you won’t see the trial limitation any more.

Please find attached changed-files.zip (1.0 KB).

Let us know if it worked for you.

kenankocer · February 9, 2022, 1:31pm

Hi Vladimir.litvinchik

I added the lic file to the project. I edited the csproj as you said.project structure.png (12.1 KB)
csproj.png (9.6 KB)

However, after page 2, it does not load.page not loading.png (57.7 KB)

Unlike the project you sent, I call the LoadDocumentDescription method from within the .ts file. Could it be caused by this?code.png (42.3 KB)

Thank you.

vladimir.litvinchik · February 9, 2022, 1:46pm

@kenankocer

Please try removing the cache files. In case the issue still exists can you check if there are any errors in the browser developer console F12?

kenankocer · February 9, 2022, 2:13pm

Hi ,

I cleared the cache and cache, it’s not related to it.

When we call the LoadDocumentDescription method from the code, it does not load after the 2nd page and the back and forth buttons do not work.
code.png (42.3 KB)
error1.png (47.6 KB)
error2.png (39.7 KB)
error3.png (40.6 KB)

However, everything works when the document wants to be opened from the button that opens the document tree.
error4.png (48.5 KB)
error5.png (41.1 KB)
error6.png (37.4 KB)

I guess there are methods that trigger something in between. How can I find.

vladimir.litvinchik · February 9, 2022, 3:06pm

@kenankocer

You can try to run the client (Angular App) from sources to find where the code throws.

Navigate to the samples\GroupDocs.Viewer.UI.Sample\ and enable CORS in Startup.cs

public void ConfigureServices(IServiceCollection services)
{
    services.AddCors(options => 
        options.AddPolicy("AllowAll", builder =>
        {
            builder
                .AllowAnyOrigin()
                .AllowAnyMethod()
                .AllowAnyHeader();
        }));

...

public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
    app.UseCors("AllowAll");

...

Navigate to src\GroupDocs.Viewer.UI\client\src\app\
Update configServiceFactory method in app.module.ts to

export function configServiceFactory() {
  let apiEndpoint = 'http://localhost:5000/viewer-api';
  let uiSettingsPath = 'http://localhost:5000/viewer-config';

  let config = new ConfigService();
  config.apiEndpoint = apiEndpoint;
  config.getViewerApiEndpoint = () => apiEndpoint;
  config.getConfigEndpoint = () => uiSettingsPath;
  return config;
}

Install packages npm install
Run the app ng serve
Navigate to http:\\localhost:4200 and try reproducing the issue.
Check the browser console for error and explore the code that throws.

Attaching changed-files.zip (1.7 KB) for more details.

kenankocer · February 16, 2022, 10:51am

Hi,

I fixed the problems.

Thank you very much for your interest.

vladimir.litvinchik · February 17, 2022, 7:03am

@kenankocer

Thank you for your feedback!

Can you please share what was the issue?

kenankocer · February 18, 2022, 6:03am

Hi,
I made an improvement on creating an external dowload link and sending it directly to GroupDocs as a url and opening it. In order to achieve this, I added this code block to the app.component.ts file, but since I did not import ngOninit, there was an error on page loads here. Forward and Back buttons, on the other hand, could not work properly because they could not see it in ngoninit because they looked at the navigateService component. That’s why I did the imports.

1.png (14.9 KB)
2.png (29.7 KB)
3.png (13.4 KB)

vladimir.litvinchik · February 18, 2022, 7:45am

@kenankocer

Thank you for sharing the details!

Have a nice day

kenankocer · February 18, 2022, 8:06am

Vladimir Litvinchik

Have a nice day

vladimir.litvinchik · February 18, 2022, 8:43am

@kenankocer

Thank you!