using Google.Apis.Auth.OAuth2; using Google.Apis.Gmail.v1; using Google.Apis.Gmail.v1.Data; using Google.Apis.Services; using Goog...
Read More
function running only particular time range only in c#
string startTime = "9:30 AM"; string endTime = "6:30 PM"; if (DateTime.Now >= DateTime.Parse(startTime) ...
Read More
Assign string array list of files in Folder in c#
From a Directory (e.g., all .xlsx files) string [] tFile = Directory.GetFiles( @"C:\Exports\" , "*.xlsx" );
Read More
assign values to a string[] array in C#
string [] tFile = { "file1.txt" , "file2.csv" , "file3.xlsx" }; Or: string [] tFile = new string [ 3 ]; ...
Read More
C#, you can assign values to a string[] (string array)
1. Inline Assignment with Values string[] tFile = { "file1.txt", "file2.txt", "file3.txt" }; 2. Using new Ke...
Read More
export a DataTable to Excel and upload it to AWS S3 using C# with EPPlus
using System; using System.Data; using System.IO; using OfficeOpenXml; using Amazon; using Amazon.S3; using Amazon.S3.Transfer; class Progr...
Read More
C# Example with ClosedXML and S3 Upload
using System; using System.Data; using System.IO; using ClosedXML.Excel; using Amazon; using Amazon.S3; using Amazon.S3.Transfer; using Sys...
Read More
export csv Using SQL with OPENROWSET to Write to Excel
INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\output.xlsx;HDR=YES;', 'SELECT * FROM ...
Read More
export csv using sql server SQL Server bcp (Bulk Copy Program)
SQL Server bcp (Bulk Copy Program) Command-line utility to export results to a CSV readable by Excel: bcp "SELECT * FROM YourDatabase...
Read More
Subscribe to:
Posts (Atom)