We are currently running Apose.Cells v 7.2.2.0. Is it possible in this or any newer version to use a blank space as a delimiter with which to split a file?
i.e. this would split into 4 records?
John Smith "123 abc lane" 111-222-3333
We are currently running Apose.Cells v 7.2.2.0. Is it possible in this or any newer version to use a blank space as a delimiter with which to split a file?
i.e. this would split into 4 records?
John Smith "123 abc lane" 111-222-3333
Hi,
Thanks for using Aspose.Cells.
Please use the following code with the latest version: Aspose.Cells
for .NET v8.0.0.1 and it works as expected.
The code loads the text with space as a delimiter and convert it to xlsx format. I have attached both the input and output files for your reference.
C#