C# Method to produce an EXCEL file from two LIST Arrays

In Progress Posted Jun 14, 2015 Paid on delivery
In Progress Paid on delivery

Very simple method that will take in two LIST ARRAYS and produce an EXCEL file. One list array contains the column headers for the EXCEL file and the other array contains the detail rows. This method will be used in a C# [url removed, login to view] program. All you need to do is write a method that will take in 2 LIST Arrays and produce an EXCEL file from this data.

Array 1 - for EXCEL Header (Columns)

List<FilteredValuesOfAttribure> FilteredValueOfProduct = new List<FilteredValuesOfAttribure>();.

public class FilteredValuesOfAttribure

{

public string attributeURL { get; set; }

public string attributeTtitle { get; set; }

public string value1 { get; set; }

public string id { get; set; }

}

Sample:

• Here is a sample of the data for this array. This is just a sample as contents vary. There can be up to 800 rows in this array and therefore 800 EXCEL columns,

ID Value1 attributeURL attributeTtitle

NULL NULL Kick://attribute?id=123 Color

NULL NULL Kick://attribute?id=930 Size

NULL NULL Kick://attribute?id=811 Length

NULL NULL Kick://attribute?id=330 ID

Array 2 - for EXCEL Rows

List<FilteredValuesOfAttribure> GetAllConvertedValue = new

List<FilteredValuesOfAttribure>();public class FilteredValuesOfAttribure

{

public string attributeURL { get; set; }

public string attributeTtitle { get; set; }

public string value1 { get; set; }

public string id { get; set; }

}

• Here is a sample of the data for this array. This is just a sample as contents vary. There can be up to 50,000 rows in this array.

id value attributeURL attributeTtitle

9012 Black Kick://attribute?id=123 Color

9012 Large Kick://attribute?id=930 Size

9012 Long Kick://attribute?id=811 Length

9911 Yellow Kick://attribute?id=123 Color

9911 Small Kick://attribute?id=930 Size

9911 Short Kick://attribute?id=811 Length

2934 Blue Kick://attribute?id=123 Color

2934 Med Kick://attribute?id=811 Length

3122 X-Large Kick://attribute?id=930 Size

The EXCEL file produced by this method would look like this using the data attached.

ID Color Length Size

9012 Black Long Large

9911 Yellow Short Small

2934 Blue Med

3122 X-Large

Additional details are attached.

ASP.NET C# Programming

Project ID: #7858343

About the project

11 proposals Remote project Active Jun 14, 2015

11 freelancers are bidding on average $135 for this job

agilepksolutions

Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 3+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I u More

$174 USD in 1 day
(79 Reviews)
7.7
jatindhoot

Hello, I had a close look and I promise to deliver in next 20 hours or so. Payment only upon delivery and that also before 20 hours. Thank you very much

$105 USD in 1 day
(35 Reviews)
7.2
giviniinternet

Hi, Ready to start now and will finish today. Thanks...............................................................................

$133 USD in 1 day
(118 Reviews)
6.9
srinichal

I am an expert in C# and can deliver the project to your specifications and needs .

$84 USD in 3 days
(60 Reviews)
6.7
vinod150987

Hi Hope you well ! I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 4 + years experience in .NET with C#,VB,ASP.NET MVC, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and More

$188 USD in 3 days
(22 Reviews)
4.5
spidercodesc

A proposal has not yet been provided

$166 USD in 5 days
(3 Reviews)
2.7
windowsdna

ข้อเสนอยังไม่ได้ระบุ

$111 USD in 2 days
(0 Reviews)
0.0
KavithaFreelance

Hello, I have worked in such scenario in my last project :) So feel I'm well suited for this requirement. Thanks. Regards, Kavitha

$113 USD in 3 days
(0 Reviews)
0.0
bluglasssoftware

We can have this done in a very efficient and reliable manner while not compromising on the time to completion.

$155 USD in 2 days
(0 Reviews)
0.0