Questions tagged [header-row]

31 questions
1
vote
1 answer

Partial Matches When Filtering SlickGrid

Since I don't have enough reputation to comment, I am posting this as a separate question. I am trying to implement the solution given by the user LFReD as an answer to this question: How to perform partial matches when filtering Slickgrid using…
Vabbs
  • 107
  • 14
0
votes
0 answers

Customizing the color and the style of the header row of a table using formattable

I have obtained the below table using the formattable function in R. I want to color the header row and the very last row (Total row) in color blue. I want to bold the text on the header and the word "Total" on the last row. Also, I want to add…
Darsh
  • 21
  • 1
0
votes
1 answer

When loading CSV data with pandas, the first line is mistaken for the title

How to prevent the following? When I load a file with pd.read_csv(), the first line gets unwantedly treated as a header (list of column names): import pandas as pd data = pd.read_csv('namefile',sep=' ') print(data) and only the second line onwards…
3sm1r
  • 520
  • 4
  • 19
0
votes
2 answers

vba excel listobject HeaderRowRange

I am having some problem to understand how HeaderRowRange works. Lets see: According to the documentation: headersRowrange is a Range so this should work: Dim ftsTbl As ListObject Set ftsTbl = ThisWorkbook.Sheets(1).ListObjects(1) MsgBox…
JFerro
  • 3,203
  • 7
  • 35
  • 88
0
votes
1 answer

R query: adding a header row to .txt files

I have 7 datasets (53 variables each with varying numbers of rows, all > 100k) in .txt format. There is no header row but I know the field names and correct formats for each variable. I have tried using rbind: df <-…
0
votes
2 answers

ValueError: Index DATE invalid with pandas.read_csv on header row

Trying to create a dictionary with the key's being the first row of the csv file and the value's being a dictionary of {first column: corresponding column to row}: import pandas as pd df = pd.read_csv('~/StockMachine/data_stocks.csv',…
csanders1999
  • 25
  • 1
  • 7
0
votes
1 answer

GridView with SortExpression in column - I can't read the HeaderRow to make an Excel file with EPPlus - C Sharp C#

I' ve got an issue with my program. When i do this: GridView gvw = this.ProduttoriList1.FindControl("GridViewList") as GridView; SqlDataSource dataSource = this.ProduttoriList1.FindControl(gvw.DataSourceID) as SqlDataSource; FileInfo tempXlsFile =…
0
votes
1 answer

excel vba exporting csv file quote qualifiers

I am new to vba and need some help as I can't work this out When trying to save some specific content from one of the worksheets in an excel workbook into a CSV file,I can't get the right output format. This is critical as some columns need text…
alot 2 learn
  • 1
  • 1
  • 3
0
votes
0 answers

C# Gridview - Set header row tooltip programatically

I have a gridview which has 2 header rows as below | Name | Subject1 | Subject2 | | | T | V | T | V | |-------|-----|-------|-----|-------| | John | 80 | 20 | 78 | 18 | | Ann | 75 | 18 | 68 | 15 | The…
sushu
  • 49
  • 2
0
votes
1 answer

GridViewRowCommand cant find header row textbox value

i am trying to insert into sql table using gridview header template, under the gridview rowcommand i am trying to find the control and it is not able to retrieve the value. protected void GridView1_RowCommand1(object sender, GridViewCommandEventArgs…
Beast Mode
  • 27
  • 1
  • 7
0
votes
1 answer

Angular Ng-Grid HeaderRowTemplate sorting and two rows header

I'm developping an app in angular 1.2.20 and using the ng-grid 2.0.11 and I'm having this problem : when I'm using the headerRowTemplate attribut I loose the sort functionality of ng-grid. Is there a solution to keep it. I have a second question,…
cyr
  • 63
  • 2
  • 7
0
votes
3 answers

Show or Hide SlickGrid "header" (filter) row at runtime

I'm trying to control the visibility of the HeaderRow at runtime. [Note: To clear any confusion: I'm not talking about the row with the column names; I'm talking about the row that's made visible with grid option "showHeaderRow:true"; i.e.,…
BRebey
  • 671
  • 8
  • 12
0
votes
2 answers

How to set a range as the intersection of UsedRange WITHOUT first row + Another Column?

I have a range variable "rng". I need to set rng to be the intersection of: (1) The usedrange on the sheet EXCLUDING the first column, AND (2) Column number 6, for example Currently, I have: Set rng = Intersect(.UsedRange,…
Alaa Elwany
  • 677
  • 7
  • 15
  • 20
-1
votes
1 answer

How to change the field name by using existing header row name of the table; Google BigQuery platform

enter image description heremy dataset are from google drive in csv format, already uploaded into BigQuery. (sandbox version) and I found out that the existing header row are not detected automatically. also the table have null row as gap/space and…
-1
votes
1 answer

Why does R think my imported vector of characters are numbers?

This is probably a basic question, but why does R think my vector, which has a bunch of words in it, are numbers when I try to use these vectors as column names? I imported a data set and it turns out the first row of data are the column headers…
user6472523
  • 211
  • 3
  • 8