Question to ZK Team on ZK spreadsheet

asked 2019-03-01 16:48:57 +0800

Senthilchettyin
2623 ● 3 ● 8
http://emrpms.blogspot.in...

Hello Team.

The current product which we are using ZK is the Billing Product(Point of service). In which users will create the bill with multiple item codes (one or more) and save the Bill. Each item code contains 7 to 8 columns such as item code, unit, date of service , etc.

Users are very familiar with excel , so they are asking to provide excel kind of input to enter the Item Codes with the following features

1) Arrow keys to move up and down between the item codes. 2) Tab or arrow key to key between the column of the item codes. 3) Free form enter, no drop down or no look up or no date control. Every thing they will type correctly.

Currently we are using a list box and a small modal window to enter multiple item codes.

I am aware of that, we can use grid with inline editing feature, but for moving the arrow keys, we need to write the code.

So i am thinking why we cannot use ZK Spreadsheet for this. I just explore some of the examples of ZK Spreadsheet and i came to know that we need to input excel file as data source.

Instead of excel file, can we bind a list to the ZK Spread sheet, so that after user enters the item codes, that list can be pushed to the database.

I am not sure whether i am in the right direction.

Can you please suggest me ?