GridPanel directly to Excel.

[emredagli]

Hii stevenhzj,
Firstly welcome to ExtJS world.
You said "store.data.length = 0", you should use getCount() method of store.
since "data" is config params.

[stevenhzj]

hi emredagli
ye i use getCount() is also 0.
the store is through asynchronous get. so in store.load(), use getCount() is 0,
can i use callback to getCount() ? how to do? THK!

[emredagli]

Mr. stevenhzj,
It is better to send your code.
It is hard to say what you sholud do without knowing what you are trying to do.

[stevenhzj]

hi emredagli

this the button code:

    buttons: [{
   id: 'grid-excel-button',
   text: 'Export to Excel...',
   handler: function(){
        var max = store.getCount();
        var downstore = new Ext.data.Store({ 
                    url: 'http://localhost/ExtTestWebService/Service_Test.asmx/GetArticles', // Web Service Site
                    reader: new Ext.data.XmlReader(
                    {
                    totalRecords: 'totalRecords', 
                    record: 'record', 
                    id: 'id' 
                    },
                    [
                    {name: 'id'},
                    {name: 'name'},
                    {name: 'code'},
                    {name: 'joindate'}
                    ]
                    ),
                    remoteSort: true //                     });
                    
                    downstore.on('beforeload', function(downstore) { 
                      downstore.baseParams={consql:v_consql};
                      } );
                     
                    downstore.load({params:{start:0,limit:max}}); //                     
        vExportContent = grid.getExcelXml(store.data,false);
        exportExcell();
   }
  }],

another WebService Code:

    [WebMethod]
    public DataSet GetArticles(string consql, int start, int limit, string sort, string dir)
    {
        DataSet ds = new DataSet("Operator");

        string strSql = string.Format(
"select top {0} * from sys$vw_operator where 1=1 " + consql + "  and  Id not in (select top {1} Id from sys$vw_operator order by {2} {3}) order by {2} {3}",
limit, start, sort, dir);
 
        SqlDataAdapter da = new SqlDataAdapter(strSql, _strConn);
        DataTable dtRecord = new DataTable("record");
        lock (da)
        {
            da.Fill(dtRecord);
        }
        ds.Tables.Add(dtRecord);
        DataTable dtResult = new DataTable("results");
        dtResult.Columns.Add("totalRecords");
        DataRow dr = dtResult.NewRow();
        using (SqlConnection conn = new SqlConnection(_strConn))
        using (SqlCommand cmd = new SqlCommand("select count(*) from sys$vw_operator where 1=1" + consql, conn))
        {
            try
            {
                conn.Open();
                dr["totalRecords"] = (int)cmd.ExecuteScalar();
            }
            catch
            {
                // do nothing
            }
        }
        dtResult.Rows.Add(dr);
        ds.Tables.Add(dtResult);
        return ds;
    }

[stevenhzj]

and i want know how use ext and ajaxpro2, i trying to use ,but then conflict.
in Ajaxpro, js code is easy call function c# mothod, i to bo used to.
but i can use in ext, anybody can help me , hope Demo Sample, Ths.

[rakesh]

This Code may be helpful to generate excel file on server side.

public void generateExcelFile(List<? extends EkaListingDO> listingResults,
			HttpServletResponse response, HttpServletRequest request,
			String gridName) throws SystemException {

		IUserContext userContext = this.getUserContext(request);

		try {

			String fileName = gridName + "-"
					+ EkaDateUtil.getTimeStamp(new Date());

			String dependentObj = (String) request.getParameter("dependentObj");

			JSONObject jsonDependentObj = null;

			if (EkaStringUtil.isNotEmpty(dependentObj)) {
				jsonDependentObj = JSONObject.fromObject(dependentObj);
			}

			String columnModelState = (String) request
					.getParameter("columnModelState");

			columnModelState = columnModelState.replaceAll(
					"EKA_INTERNAL_ID_AMP", "&");
			columnModelState = columnModelState.replaceAll(
					"EKA_INTERNAL_ID_HASH", "#");

			OutputStream out = null;

			response.setContentType("application/vnd.ms-excel");
			response.setHeader("Content-Disposition", "attachment; filename="
					+ fileName + ".xls");
			WritableWorkbook w = Workbook.createWorkbook(response
					.getOutputStream());
			WritableSheet s = w.createSheet(gridName, 0);

			JSONArray array = JSONArray.fromObject(columnModelState);

			List<String> listProperties = new ArrayList<String>();

			for (int i = 0; i < array.size(); i++) {

				JSONObject object = (JSONObject) array.get(i);

				listProperties.add(object.getString("dataIndex"));

				s.addCell(new Label(i, 0, object.getString("header")));

			}

			String value = null;

			if (!listProperties.isEmpty()) {

				for (int i = 0; i < listingResults.size(); i++) {
					EkaListingDO ekaListingDO = (EkaListingDO) listingResults
							.get(i);

					for (int j = 0; j < listProperties.size(); j++) {

						value = (String) EkaBeanUtil.getBeanProperties(
								ekaListingDO, listProperties.get(j));

						if (EkaStringUtil.isNullOrEmpty(value)) {
							value = "";
						}

						if (jsonDependentObj != null
								&& jsonDependentObj.containsKey(listProperties
										.get(j))) {
							JSONArray array2 = (JSONArray) jsonDependentObj
									.get(listProperties.get(j));

							for (int k = 0; k < array2.size(); k++) {
								JSONObject innObj = array2.getJSONObject(k);

								String property = innObj.getString("dependsOn");
								String separator = innObj
										.getString("separator");

								String dependentValue = (String) EkaBeanUtil
										.getBeanProperties(ekaListingDO,
												property);

								if (EkaStringUtil.isNullOrEmpty(dependentValue)) {
									dependentValue = "";
								}
								if (EkaStringUtil.isNotEmpty(value)) {
									value = value + separator + dependentValue;
								}

							}

						}

						if (EkaStringUtil.isDoubleContent(value)
								|| EkaStringUtil.isOnlyNumericContent(value)) {
							s.addCell(new Number(j, i + 1, EkaStringUtil
									.convertStringToDouble(value)));
						} else {
							s.addCell(new Label(j, i + 1, value));
						}

					}
				}
			}

			w.write();
			w.close();

			if (out != null) {
				out.close();

			}

		} catch (Exception e) {
			logger.error(userContext, e);
		}

	}

[NoahK17]

As an update to my previous issue with OpenOffice vs. MS Excel -- having MS Excel installed worked like a charm opening the generated XLS file. Sorry OpenOffice, you lose this round!

[hardc0re]

bad post

[Animal]

So you didn't' read the message, and try to find the mistake then? You just blurted your bug here.

READ the XML section which the error message kindly tells you about, and you see

 <Worksheet ss:Name=". la 31.12.2008.xls]Contracte valide si in vigoare">

Excel seems not to like that.

READ the free code which generates that section, and you see:

//      Generate worksheet header details.
        var t = '<ss:Worksheet ss:Name="' + this.title + '">' +

Do some work.

[hardc0re]

thanks i think i did it