Is there any way to specify the encoding UTF-8 in SpreadsheetGear to generate CSV files?

Below is my sample VB.net code to generate CSV file but I don’t find a way to specify UTF-8 encoding. Can anyone help me on this? Public Sub GenerateCsvFile(ByVal dt As DataTable, ByVal strFilePath As String) Dim workbook As SpreadsheetGear.IWorkbook Dim worksheet As SpreadsheetGear.IWorksheet workbook = SpreadsheetGear.Factory.GetWorkbook() worksheet = workbook.Worksheets(“Sheet1”) Dim cells As SpreadsheetGear.IRange cells…

Details

Selecting max value across columns opposed to across rows

I am attempting to select the max value within separate columns per a dimension listed in a row as so; Input Dataset Person|Date#1 |Date#2 |Date#3 |Date#4 ——+——–+——–+——–+——— Matt |12/01/18|01/15/19|02/15/19|04/15/18 Dave |01/15/18|01/02/19|03/15/19|11/01/19 Desired result Input Dataset Person|Max Date| ——+——–+ Matt |02/15/19| Dave |11/01/19|

Details

MongoDB: “Unknown top level operator ‘nameOnly’ ” error from Java, but everything is ok from Mongo Shell

We have an interesting problem. We have a java application (Java 8, Spring boot, MongoDB driver 3.8.2) with a simple MongoDB GUI tool. Case 1. My dev local machine. MongoDB 3.6.0. Non-admin user. Part of the java-code: mongoClient.listDatabaseNames() returns list of the available database names. Everything is fine. Case 2. Remote server. MongoDB 3.6.0. Non-admin…

Details

how Dispose / close stream of “TiffBitmapDecoder”

var filePath= @”c:\user\image.tif”; TiffBitmapDecoder TifDec = new TiffBitmapDecoder(new Uri(path), BitmapCreateOptions.IgnoreImageCache, BitmapCacheOption.OnDemand); File.Delete(pathFile); is throw exception “System.IO.IOException: ‘The process cannot access the file ‘c:\user\image.tif’ because it is being used by another process.” this code not working var filePath = @”c:\user\image.tif”; TiffBitmapDecoder TifDec = new TiffBitmapDecoder(new Uri(filePath), BitmapCreateOptions.IgnoreImageCache, BitmapCacheOption.OnDemand); TifDec.Dispatcher.InvokeShutdown(); TifDec.Dispatcher.DisableProcessing(); while (!TifDec.Dispatcher.HasShutdownFinished) Thread.Sleep(10); File.Delete(filePath); Error screenshot

Details