0

I was asked to produce an Excel file of a specific format, using text as input. User will input text into a TextBox in asp.net, which I will parse/process and export to Excel.

Since the Excel file format is specified, I am thinking of using Reporting Services 2005 and vb.net. I am open to any other suggestion though, provided that vb.net will be used.

Thanks in advance :)

3
  • I have tried to parse the text given to make it xml. Commented Sep 5, 2013 at 9:20
  • if you are happy with xml spreadsheet (.xlsx), try OpenXML, google it and you will find tons of samples online Commented Sep 5, 2013 at 9:30
  • I thought of converting the text to xml (file or text) and then pass it dynamically as Datasource to the report. And this is where I can't find a solution Commented Sep 5, 2013 at 9:53

1 Answer 1

0

Why do you want to use reporting tools for this? If I understand your problem correctly, you can very easily using this link

Using VB.NET to write to excel

Sign up to request clarification or add additional context in comments.

1 Comment

Users need a report that can be exported to Excel.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.