C# Method to produce an EXCEL file from two LIST Arrays
$30-250 USD
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.
Project ID: #7858343
About the project
11 freelancers are bidding on average $135 for this job
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
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
Hi, Ready to start now and will finish today. Thanks...............................................................................
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
Hello, I have worked in such scenario in my last project :) So feel I'm well suited for this requirement. Thanks. Regards, Kavitha
We can have this done in a very efficient and reliable manner while not compromising on the time to completion.