Need another workbook open method overload to support loading string seperated files

Aspose.Cells Product Family
1

Hi There,

Thank you for continuing support here on ASPOSE forum.

We need an overload method on Workbook.Open() which takes, filePath and seperater as string.

Something like this, workbook.open(string filePath, string seperator).

Is it possible to get one overload on Open method?

We need it basically to import file seperated by different character/characterS(string)

Thank you,

Bhavin

2

Hi Bhavin,

Thanks for your inquiry.

We need to discuss your desired feature with other developers in the team to check if we can support it. We have to analyze its feasibility first against all aspects.

We will update you soon about it.

Thank you.

3

Hi,

We have analyzed it a bit. Could you post us a template file first we should check whether MS Excel could open such a file or not. Also, if MS Excel create and open such a file, still we cannot support it soon as we have some other important tasks (on hand) to be supported urgently.

Thanks for your understanding!

4

Hi Amjad,

Thank you for taking our need in to consideration.

We understand the priority on your hand.

We thought, it would be poweful feature for aspose and useful for their users.

Ofcourse, we can implement class of our own which will split up the string from input file and dump seperated values into range and then we copy that range into target/destination worksheet range.

I have attached "txt" file.

Just wondering, do you have anything where users can vote for feature that they need/want?

Thanks again for your continued support,

Cheers, Bhavin

5

Hi Bhavin,

Thanks for sharing the template file and details.

We will support your desired feature after some time. Anyways, we have logged your feature request into our internal issue tracking system with an issue id: CELLSNET-11960.

Kindly keep in touch.

Thank you.

6

Hi,

Please try the attached version.

We have provided an overloaded version for “Open” method to open the csv file with string
separator. See following code:

Workbook workbook = new Workbook();
workbook.Open("string-seperated.txt", "*#*");
workbook.SaveToCSV("Test_29205.txt", "*#*");


Thank you.
7

Hi Amjad,

Thanks million for providing a overloaded version of "Open" method.

I have tested new feature and obviously every new feature introduces new bug.

So, does this feature too have bug :)

When text file has empty column/cell in it, it stuffs up the import.

e.g.

*#*123*#*654*#**#*631

When i open text file with "*#*" string seperator, it doesn't read properly.

Can you confirm that you have the same issue as well?

Again thanks alot for your continued support.

Cheers, Bhavin

8

Hi,

We found the issue after the initial test, we will fix it soon.

Thank you.

9

Hi Bhavin,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells for .NET. We have fixed your mentioned issue.

Thank You & Best Regards,

10

The issues you have found earlier (filed as 11960) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.