Excel   35348

« earlier    

Excel Application Events And VBA
Example VBA to run every time a new workbook is opened
vba  excel  automation 
yesterday by ktr
densitydesign/raw: The missing link between spreadsheets and data visualization
RAWGraphs is an open web tool to create custom vector-based visualizations on top of the amazing d3.js library by Mike Bostock. It has been developed by DensityDesign Research Lab (Politecnico di Milano) and Calibro, and sustained through a corporate stewardship by ContactLab.

Primarily conceived as a tool for designers and vis geeks, RAWGraphs aims at providing a missing link between spreadsheet applications (e.g. Microsoft Excel, Apple Numbers, Google Docs, OpenRefine, …) and vector graphics ...
spreadsheet  excel  CSV  visualisation  visualization  visual  SVG  google  doc  apple  numbers  D3  generate  transform  data  tabular  illustrator  inkscape 
yesterday by ebouchut
SheetJS/js-xlsx: SheetJS Community Edition -- Spreadsheet Parser and Writer
Parser and writer for various spreadsheet formats. Pure-JS cleanroom implementation from official specifications, related documents, and test files. Emphasis on parsing and writing robustness, cross-format feature compatibility with a unified JS representation, and ES3/ES5 browser compatibility back to IE6.
javascript  excel  library 
yesterday by bouvin
Excel formula: Remove leading and trailing spaces from text | Exceljet
=TRIM(CLEAN(SUBSTITUTE(B1,CHAR(160)," ")))

SWEET IT WORKS
excel 
2 days ago by maoxian
Excel formula: Add line break based on OS | Exceljet
automatically appry the right char line break based on system
=IF(INFO("system")="mac",CHAR(13),CHAR(10))
excel 
3 days ago by diam0nd
TEXT function - Office Support
how to output current time

=TEXT(NOW(),"H:MM AM/PM")

Current time, like 1:29 PM
excel  vba 
3 days ago by diam0nd
[Solved] Macro Button Code, SaveAs PDF w/ file name from cell
Sub DesktopPDF()

'Set path to Desktop
fPath = " ***Insert Path To Desktop Here*** \Desktop"

'Build File Name from Sheet1 O30, O31 & A1
fName = Sheets(1).Range("O30") & "-" & _
Sheets(1).Range("O31") & "-" & _
Sheets(1).Range("A1")

'Export as PDF to Desktop
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=fPath & fName, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True

End Sub
excel  vba  pdfs 
3 days ago by diam0nd

« earlier    

related tags

37  38  44  47  address  ai  airtable  alternative  amiante  angular  api  apple  applescript  automation  baseball  biased  business  cell  chart  charts  checkpoint  checkpoints  cloud  cms  codable  collaboration  competition  computervision  crm  csst  csv  d3  data  dataanalysis  database  datacarpentry  datamining  datascience  datawrangling  date  datenschutz  declustering  dev  development  doc  documentation  dotnet  dotnetcore  email  en  example  excel  fi  files  fire  floss  font  forum  generate  gif  github  google  graph  graphviz  gsuite  guide  hack  hacking  how_to  howto  html  illustrator  images  inkscape  instapaper  internet  ip  javascript  json  keyboardmaestro  libraries  library  ligne  mac  management  markdown  microsoft  ms  mvpsummit  networking  ng  nocode  nodejs  numbers  onpremise  openrefine  opensource  opismenjevanje  orodij  package  pandas  parse  parsing  password  pdf  pdfs  php  pivot  pivottable  plugin  podbot  powerquery  powershell  ppt  preservation  productivity  productmanagement  programming  proportional  prévention  python  r  raba  read  reading  reference  registre  regneark  scanning  scorecards  scraping  security  selfhosted  sharepoint  sheet  sheets  software  spatial  spreadsheet  sql  sumif  svg  swift  tabellenkalkulation  table  tabular  tolearn  tools  totry  tounderstand  tradestation  transform  tutorial  twinztechtalk  twinztechtip  type  update  vba  visual  visualisation  visualization  vlookup  word  wordpress  work  workshop  xlsx  xml  youtube 

Copy this bookmark:



description:


tags: