Click here to Skip to main content
15,884,629 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
The following is the code that i have. On debugging it shows two errors:
Bytescout.spreadsheet is a 'namespace'; but is used like a 'type'.

The following is the code:
C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Bytescout.Spreadsheet.Demo.Csharp.ExportTo2DArray
{
    class Program
    {
        static void Main(string[] args)
        {
            const string inputFile = @"data.xls";

            // Open and load spreadsheet
            Spreadsheet spreadsheet = new Spreadsheet(); //**error in this line
            spreadsheet.LoadFromFile(inputFile);

            // Get the data from the spreadsheet
            string[,] data = spreadsheet.ExportTo2DArray();

            // Close spreadsheet
            spreadsheet.Close();

            // Display data in data table
            for (int i = 0; i < data.GetLength(0); i++)
            {
                for (int j = 0; j < data.GetLength(1); j++)
                {
                    Console.Write(data[i, j] + " ");
                }
                Console.WriteLine();
            }

            // Pause
            Console.ReadLine();
        }
    }
}
Posted
Updated 17-Jan-16 22:10pm
v2
Comments
Kornfeld Eliyahu Peter 18-Jan-16 4:04am    
The compiler identify Spreadsheet as namespace because of this - namespace Bytescout.Spreadsheet.Demo.Csharp.ExportTo2DArray...
What Spreadsheet did you meant?
Richard MacCutchan 18-Jan-16 5:16am    
Just change your namespace to something more sensible, and different from the type names you are trying to use in the program.

1 solution

Since you paid a lot of money to license this commercial product, and your code here is directly copied from their web-site [^], why don't you submit a support ticket ? If you are using a "trial" version, is it possible the trial has expired ?

The most common cause of the kind of error you report would be that you do not have a proper reference set to a necessary dll. In Visual Studio Solutions Explorer open 'References and examine what is there; if necessary select 'Add Reference from its context menu and do the right thing to find the required dll.

Try putting this in the 'using statements:

using ByteCount;

And see if that compiles.
 
Share this answer
 
Comments
Kornfeld Eliyahu Peter 18-Jan-16 5:31am    
The really nice thing that for a starting price of $500 one should expect working samples...That code on the site does not work at all - and you do not need a compile to tell that...
BillWoodruff 18-Jan-16 11:46am    
The syntax definitely makes you wonder, but keeping in mind that .NET will give you enough rope to hang yourself and compile this:

namespace YourFamily.YourMother.YourFather.YourSiblings.AllTheRelatives

You gotta consider the potential the code might work in spite of ...
Member 12247039 18-Jan-16 6:12am    
Yes i did copy the code. But the code gave errors. So i posted it here.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900