C# For WebInfo Solutions
₹12500-37500 INR
Pago na entrega
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.
Skills required:
ASP.NET, C# Programming
Additional Files: Method to produce EXCEL [login to view URL]
ID do Projeto: #7858485
Sobre o projeto
10 freelancers estão ofertando em média ₹16511 nesse trabalho
Good Day , I am ready to start work with you i have did it before more than one time i have 7 years of experience and also i will support you for any new modifications looking forward to hearing from you Thanks
Hi, I have a working sample for the project at ju.somee.com. Please note that I have used commas as the delimiter. If you need to use spaces or anything else, that can be easily changed. Please review it and let Mais
Hello, I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Prod Mais
Hello. Have a good expirience of creatiation of excel reports for ASP.Net and desctop applications. It's standart task, that don't take a lot of time and will be worked perfect. Best regards.
Already done something similar in my job, only need to communicate which format to write xlsx? And would be better if first array was just strings (Headers)?