using System;
using OfficeOpenXml;
using System.IO;
namespace EmployeeDataCapture
{
class Program
{
static void Main(string[] args)
{
// Create a new Excel package
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (ExcelPackage package = new ExcelPackage())
{
// Create a new worksheet
ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Employee Data");
// Set column names
string[] columnNames = { "First Name", "Surname", "ID Number", "Trade", "Stamp Number",
"Stamp Expiry Date", "Area", "Site", "Forum Name", "Medical Station",
"Medical Expiry Date", "Contact", "Alt Contact", "Comments" };
for (int i = 0; i < columnNames.Length; i++)
{
worksheet.Cells[1, i + 1].Value = columnNames[i];
}
// Prompt user for data entry
Console.WriteLine("Enter employee data. Press 'q' to quit.");
int row = 2;
while (true)
{
Console.Write("First Name: ");
string firstName = Console.ReadLine();
if (firstName.ToLower() == "q")
break;
Console.Write("Surname: ");
string surname = Console.ReadLine();
Console.Write("ID Number: ");
string idNumber = Console.ReadLine();
Console.Write("Trade: ");
string trade = Console.ReadLine();
Console.Write("Stamp Number: ");
string stampNumber = Console.ReadLine();
Console.Write("Stamp Expiry Date (yyyy-mm-dd): ");
DateTime stampExpiryDate = DateTime.Parse(Console.ReadLine());
Console.Write("Area: ");
string area = Console.ReadLine();
Console.Write("Site: ");
string site = Console.ReadLine();
Console.Write("Forum Name: ");
string forumName = Console.ReadLine();
Console.Write("Medical Station: ");
string medicalStation = Console.ReadLine();
Console.Write("Medical Expiry Date (yyyy-mm-dd): ");
DateTime medicalExpiryDate = DateTime.Parse(Console.ReadLine());
Console.Write("Contact: ");
string contact = Console.ReadLine();
Console.Write("Alt Contact: ");
string altContact = Console.ReadLine();
Console.Write("Comments: ");
string comments = Console.ReadLine();
// Store the data in the worksheet
worksheet.Cells[row, 1].Value = firstName;
worksheet.Cells[row, 2].Value = surname;
worksheet.Cells[row, 3].Value = idNumber;
worksheet.Cells[row, 4].Value = trade;
worksheet.Cells[row, 5].Value = stampNumber;
worksheet.Cells[row, 6].Value = stampExpiryDate;
worksheet.Cells[row, 7].Value = area;
worksheet.Cells[row, 8].Value = site;
worksheet.Cells[row, 9].Value = forumName;
worksheet.Cells[row, 10].Value = medicalStation;
worksheet.Cells[row, 11].Value = medicalExpiryDate;
worksheet.Cells[row, 12].Value = contact;
worksheet.Cells[row, 13].Value = altContact;
worksheet.Cells[row, 14].Value = comments;
row++;
}
// Save the Excel file
Console.Write("Enter the file path to save the Excel file: ");
string filePath = Console.ReadLine();
package.SaveAs(new FileInfo(filePath));
}
Console.WriteLine("Excel file created successfully!");
}
}
}
Write, Run & Share C# code online using OneCompiler's C# online compiler for free. It's one of the robust, feature-rich online compilers for C# language, running on the latest version 8.0. Getting started with the OneCompiler's C# compiler is simple and pretty fast. The editor shows sample boilerplate code when you choose language as C# and start coding.
OneCompiler's C# online compiler supports stdin and users can give inputs to programs using the STDIN textbox under the I/O tab. Following is a sample program which takes name as input and print your name with hello.
using System;
namespace Sample
{
class Test
{
public static void Main(string[] args)
{
string name;
name = Console.ReadLine();
Console.WriteLine("Hello {0} ", name);
}
}
}
C# is a general purpose object-oriented programming language by Microsoft. Though initially it was developed as part of .net but later it was approved by ECMA and ISO standards.
You can use C# to create variety of applications, like web, windows, mobile, console applications and much more using Visual studio.
| Data Type | Description | Range | size |
|---|---|---|---|
| int | To store integers | -2,147,483,648 to 2,147,483,647 | 4 bytes |
| double | to store large floating point numbers with decimals | can store 15 decimal digits | 8 bytes |
| float | to store floating point numbers with decimals | can store upto 7 decimal digits | 4 bytes |
| char | to store single characters | - | 2 bytes |
| string | to stores text | - | 2 bytes per character |
| bool | to stores either true or false | - | 1 bit |
datatype variable-name = value;
When ever you want to perform a set of operations based on a condition or set of few conditions IF-ELSE is used.
if(conditional-expression) {
// code
}
else {
// code
}
You can also use if-else for nested Ifs and If-Else-If ladder when multiple conditions are to be performed on a single variable.
Switch is an alternative to If-Else-If ladder.
switch(conditional-expression) {
case value1:
// code
break; // optional
case value2:
// code
break; // optional
...
default:
// code to be executed when all the above cases are not matched;
}
For loop is used to iterate a set of statements based on a condition.
for(Initialization; Condition; Increment/decrement) {
// code
}
While is also used to iterate a set of statements based on a condition. Usually while is preferred when number of iterations are not known in advance.
while(condition) {
// code
}
Do-while is also used to iterate a set of statements based on a condition. It is mostly used when you need to execute the statements atleast once.
do {
// code
} while (condition);
Array is a collection of similar data which is stored in continuous memory addresses. Array values can be fetched using index. Index starts from 0 to size-1.
data-type[] array-name;
Method is a set of statements which gets executed only when they are called. Call the method name in the main function to execute the method.
static void method-name()
{
// code to be executed
}