nithilas Posts - Answer Overflow

nithilas

•Created by nithilas on 2/21/2023 in #help

❔ Syncfusion XlsIO for Blazor

I have a workbook with a mainsheet ("OverzichtJumbo") and multiple other sheets which I need to get some data from. I'm trying to use the formula XLOOKUP to get this data, formula works when I try it in Excel directly, but it gives me following error:

Error: Syncfusion.XlsIO.Implementation.Exceptions.ParseException: XLOOKUP isn't custom function. at position 1. Formula: XLOOKUP(OverzichtJumbo!$A2;FirstTab!$A:$A;FirstTab!$B:$B;na;0;1), Position: 8

To add the formula to the sheet I use following code:

worksheetOverzicht.Range[$"C{count}"].Formula= $"=XLOOKUP(OverzichtJumbo!$A{count};FirstTab!$A:$A;FirstTab!$B:$B;na;0;1)";

Am I doing something wrong here or do I need a different approach if I want to use the XLOOKUP formula? Thank you for the help.

2 replies

CC#

•Created by nithilas on 1/8/2023 in #help

❔ Fluent FTP Problem

Currently writing a little C# program to connect to FTP server and download some files. Connecting to the server is no problem but as soon as i try to retrieve folders, files etc. I get a error

Code: 450 Message: TLS session of data connection has not resumed or the session does not match the control connection

My code is as follows:

 using var conn = new FtpClient("host", "login", "pw", port);
            conn.Config.EncryptionMode = FtpEncryptionMode.Explicit;
            conn.Config.ValidateAnyCertificate = true;
            conn.Config.SslProtocols = SslProtocols.Tls12;
            conn.Connect();

            foreach (var item in conn.GetListing("/", FtpListOption.Recursive))
            {
                switch (item.Type)
                {

                    case FtpObjectType.Directory:

                        Console.WriteLine("Directory!  " + item.FullName);
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));

                        break;

                    case FtpObjectType.File:

                        Console.WriteLine("File!  " + item.FullName);
                        Console.WriteLine("File size:  " + conn.GetFileSize(item.FullName));
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));
                        Console.WriteLine("Chmod:  " + conn.GetChmod(item.FullName));

                        break;

                    case FtpObjectType.Link:
                        break;
                }
            }

 using var conn = new FtpClient("host", "login", "pw", port);
            conn.Config.EncryptionMode = FtpEncryptionMode.Explicit;
            conn.Config.ValidateAnyCertificate = true;
            conn.Config.SslProtocols = SslProtocols.Tls12;
            conn.Connect();

            foreach (var item in conn.GetListing("/", FtpListOption.Recursive))
            {
                switch (item.Type)
                {

                    case FtpObjectType.Directory:

                        Console.WriteLine("Directory!  " + item.FullName);
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));

                        break;

                    case FtpObjectType.File:

                        Console.WriteLine("File!  " + item.FullName);
                        Console.WriteLine("File size:  " + conn.GetFileSize(item.FullName));
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));
                        Console.WriteLine("Chmod:  " + conn.GetChmod(item.FullName));

                        break;

                    case FtpObjectType.Link:
                        break;
                }
            }

Any tips or suggestions?

2 replies

CC#

•Created by nithilas on 1/6/2023 in #help

❔ Fluent FTP Error message

Currently writing a little C# program to connect to FTP server and download some files. Connecting to the server is no problem but as soon as i try to retrieve folders, files etc. I get a error Code: 450 Message: TLS session of data connection has not resumed or the session does not match the control connection My code is as follows:

 using var conn = new FtpClient("host", "login", "pw", port);
            conn.Config.EncryptionMode = FtpEncryptionMode.Explicit;
            conn.Config.ValidateAnyCertificate = true;
            conn.Config.SslProtocols = SslProtocols.Tls12;
            conn.Connect();

            foreach (var item in conn.GetListing("/", FtpListOption.Recursive))
            {
                switch (item.Type)
                {

                    case FtpObjectType.Directory:

                        Console.WriteLine("Directory!  " + item.FullName);
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));

                        break;

                    case FtpObjectType.File:

                        Console.WriteLine("File!  " + item.FullName);
                        Console.WriteLine("File size:  " + conn.GetFileSize(item.FullName));
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));
                        Console.WriteLine("Chmod:  " + conn.GetChmod(item.FullName));

                        break;

                    case FtpObjectType.Link:
                        break;
                }
            }

 using var conn = new FtpClient("host", "login", "pw", port);
            conn.Config.EncryptionMode = FtpEncryptionMode.Explicit;
            conn.Config.ValidateAnyCertificate = true;
            conn.Config.SslProtocols = SslProtocols.Tls12;
            conn.Connect();

            foreach (var item in conn.GetListing("/", FtpListOption.Recursive))
            {
                switch (item.Type)
                {

                    case FtpObjectType.Directory:

                        Console.WriteLine("Directory!  " + item.FullName);
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));

                        break;

                    case FtpObjectType.File:

                        Console.WriteLine("File!  " + item.FullName);
                        Console.WriteLine("File size:  " + conn.GetFileSize(item.FullName));
                        Console.WriteLine("Modified date:  " + conn.GetModifiedTime(item.FullName));
                        Console.WriteLine("Chmod:  " + conn.GetChmod(item.FullName));

                        break;

                    case FtpObjectType.Link:
                        break;
                }
            }

Any tips or suggestions? Thanks.

2 replies

Gaming

Programming