handsontable empty lines . how to avoid

[Tharindu Dissanayake]

. Iam new to handsontable. please help me to solve this issue. i have mysql table called today_plan. i have a column plandate so i need to get records which are in today. ex 7/24/2013

i tried in hanstable my output is like this. it produced empty row for plandate=7/23/2013 how can i remove this empty line in the handsontable

result should be like following.

please give solution, thank u very much

[codename-]

How your data looks like? Maybe try to filter (https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/filter) data before loading it to Handsontable?
I suppose that you have empty rows in your data, so this problem is related to your query from db, not directly with Handsontable.

[dharm...@technorex.in]

On Thursday, 25 July 2013 08:36:57 UTC+5:30, Tharindu Dissanayake wrote:
> . Iam new to handsontable. please help me to solve this issue. i have mysql table called today_plan. i have a column plandate so i need to get records which are in today. ex 7/24/2013
>
>
>
>
>

> i tried in hanstable my output is like this. it produced empty row for plandate=7/23/2013 how can i remove this empty line in the handsontable
>
>
>
>
>

> result should be like following.
>
>
>
>
>

> please give solution, thank u very much

I did something like this:

var gridData = hot1.getData();
var cleanedGridData = {};

$.each( gridData, function( rowKey, object) {
if (!hot1.isEmptyRow(rowKey)) cleanedGridData[rowKey] = object;
});

Web & Mobile App Development Company, India
Technorex Solutions
http://technorexsolutions.com/