0

I wrote an app which is generating some report and after clicking right button it exports all data to Excel. When I personally use it I don't want to press button. I want to do: CTRL+A, CTRL+C and paste it to Excel.

The problem here is that after CTRL+V it pastes 241 rows to Excel but in report there are 244 rows. It cuts 3 rows. I have no idea why, I tought that there is a limit but when I'm generating report with less rows it also cuts 2 rows. Any idea why is it happening ?

BTW: I didn't write any method for copying so I couldn't screw anything. I would be grateful if someone would help me.

Sinatr
  • 20,892
  • 15
  • 90
  • 319
MajkeloDev
  • 1,661
  • 13
  • 30

2 Answers2

0

Are you using a web app or a windows app?

You could mimic the button press using a key combination (like ctrl+v) if it's a web app

Look here for more information:

http://dmauro.github.io/Keypress/

Prashant Kamdar
  • 414
  • 2
  • 5
  • 13
0

Have a look at this WPF datagrid pasting, it helped me when I was implementing similar functionality.

Community
  • 1
  • 1
NeddySpaghetti
  • 13,187
  • 5
  • 32
  • 61