C# Method to produce an EXCEL file from two LIST Arrays
$30-250 USD
Sürüyor
İlan edilme: neredeyse 9 yıl önce
$30-250 USD
Teslimde ödenir
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# [login to view URL] 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.
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 used to develop systems using latest adaptive technology such as
1. .NET/ASP.NET - MVC4,MVC5 - Entity Framework - SQL - C# (for .NET solutions)
2. JQuery/Javascript/HTML5 - Angular.js/Bootstrap etc (for designing and front end implementations)
I want to start work immediately and awaiting for your positive response on skp id "agilepksolutions" so I can show you some of my Quality Development Work as well as we can discuss
project in details.
Thank you.
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
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 HTML.