C# For WebInfo Solutions
₹12500-37500 INR
Dibayar saat pengiriman
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 Proyek: #7858485
Tentang proyek
9 freelancer rata-rata menawar ₹16957 untuk pekerjaan ini
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 Lebih banyak
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 Lebih banyak
Hi, I am an individual freelance, having more than 11yrs of exp in developing applications, desktop& web based, using .Net (C#.Net, Asp.Net (MVC), XML, WPF, WCF (Webservices) kendo ui, office automation(outlook, wor Lebih banyak
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)?
Hello, I am an experienced C# developer. I have also worked with creating excel files and I have done plenty of work with list management. What you are asking is done pretty easily. In fact I'm thinking of a method Lebih banyak